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 Type||SSIS Functionality|
|INI File||Package Configuration|
|Query||Execute SQL Task, Variable, Expression|
|Environment Variable||Package Configuration|
|Data File||Package Configuration|
Good luck in your migration!
Version: SQL Server 2000 SP4, SQL Server 2005 SP2