SQL Server Performance

Migration DTS packages to SSIS (2005)

Discussion in 'SQL Server 2005 Integration Services' started by iambhushan, Jun 28, 2006.

  1. iambhushan New Member

    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


    Bhushan Kalla

Share This Page