migrate dynamic properties

hi,

How do you migrate dynamic properties? I think successful rate is 0% in my tests. Does anyone have an example to show me?

What do you mean "dynamic properties"? Package configurations?|||

hi, I think your looking for this information. Its a good idea to review the whole article but pasted below what I believe is the relevant information.

SQL Server 2005 Books Online

Known Package Migration Issues

http://msdn2.microsoft.com/en-us/library/ms143462.aspx

Replace functionality of Dynamic Properties task after package migration

The SQL Server 2005 Integration Services (SSIS) Package Migration Wizard does not migrate Dynamic Properties tasks in SQL Server 2000 Data Transformation Services (DTS) packages. After migration, you must manually edit the resulting SSIS package to restore former package behavior.

Corrective action: After migration, re-create the functionality of the Dynamic Properties task by using Integration Services features such as variables, property expressions, and package configurations. For more information, see Integration Services Variables and Using Variables in Packages; Using Property Expressions in Packages; and Package Configurations.