Migrating DTS Packages to SSIS

  • [font="Comic Sans MS"]Hi all,

    Can any body tell me how to migrate SQL Server 2000 DTS packages to SSIS, i am in very much need of it... i have 5 packages in my sql server 2000 i need to migrate that to SQL Server 2005.. please help me out\

    Rgrds

    Sunil [/font]

  • There's a DTS 2000 runtime for SQL Server 2005 so you can run them. Otherwise, rewrite them in SSIS.

  • [font="Comic Sans MS"] I successfully completed migration of DTS packages from sql server 2000 to sql server 2005. but afer migration i am not able to see dts packages.

    Is there any step still pending to view this dts packages?[/font]

  • check on the 2005 console -> management - > legacy -> dts you should see them there

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply