SQL Server Performance Forum – Threads Archive
Migration DTS packages to SSIS (2005)
Hi Everyone, We are migrating from SQL Server 2000 to 2005 so my job responsbility is to migrate the DTS packages to SSIS packages (.dtsx). I haven’t encoutered any problems in migrating DTS packages so far, even the DTS packages with ActiveX script. But few of the articles on online says that the DTS packages with ActiveX scripts cannot be migrated to 2005 and they would fail while migrating them. Now, I am confused because I never got any issues with DTS packages with ActiveX scripts so I don’t know whether I am doing right or wrong. I really appreciate If any one know or has a list of exceptions to DTS packages which cannot be migrated to 2005 that would be really a great help. Thanks, BhushanBhushan Kalla
]]>