Ravi Khanal

If You are planning to migrate DTS Package of SQL Server 2000 to SQL Server 2008’s SSIS Package then first open the Sql Server Management Studio. Connect to the database engine and open the Migration Wizard as shown in the image.

 

I have my DTS package on my File System, so I am choosing Structured Storage File. If you have your DTS Package on the Database then you can choose the Source as SQL Server.

 

 

 

 

 

 

 

Then You have to choose the destination. In my case again I am using DTSX file as my destination.

 

 

 

 

 

 

 

 

Then you can choose the package and edit the destination package name.

 

 

 

 

 

 

 

Then you can specify the log file.

 

 

 

 

 

 

 

 

Then the Package Migration is completed.