June 28, 2006 at 1:55 pm
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,
Bhushan
June 28, 2006 at 6:57 pm
It is my understanding that it primarily depends on the code inside your activeX scripts. Scripts which access the package object (which no longer exists) won't migrate over.
However, even if the scripts do migrate, you are still better off re-writting them in the new script object because the old one isn't likely to be supported in the next version of SSIS.
June 29, 2006 at 9:03 am
Thank for your reply.
Bhushan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply