Thursday, March 27, 2008

Migrating the Dynamic Property Task

The DTS Dynamic Property Task does not have a one-to-one migration path to SSIS. To emulate the same functionality, you can use package configurations, variables, expressions, or decide to get rid of the dynamic property piece entirely. Which of these options you choose is completely dependent on your scenario, but I’ve put together a quick and dirty mapping from the type of dynamic property to the new SSIS functionality.

DTS Dynamic Property Task TypeSSIS Functionality
INI FilePackage Configuration
QueryExecute SQL Task, Variable, Expression
Global VariableExpression
Environment VariablePackage Configuration
Data FilePackage Configuration

Good luck in your migration!

Version: SQL Server 2000 SP4, SQL Server 2005 SP2

No comments: