Migration from DTS 2000… | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Migration from DTS 2000…

We are migrating DTS 2000 packages to SQL Server 2005 SSIS. We are facing following migrations issues : 1) For Activex Script using DTS Global variables – As per Microsoft documentation this is not supported in SSIS 2005, any alternatives?
2) Using Dynamic Properties of DTS 2000 – again, any alternatives Pl. let me know if you have any solution for the same.
Thanks,
Ram "It is easy to write code for a spec and walk in water, provided, both are freezed…"
Check this MSDN2 help page:http://msdn2.microsoft.com/en-US/library/ms143462(SQL.90).aspx about known migration issues.
Useful articles about migration :
http://msdn2.microsoft.com/en-US/library/ms143552(SQL.90).aspx
http://www.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp
http://www.simple-talk.com/2005/11/18/dts-to-ssis-migration/ Fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks for the links satya Thanks,
Ram "It is easy to write code for a spec and walk in water, provided, both are freezed…"
]]>