DTS to SSIS package migration, unable to find migrated package?
Yikes, I can't see the DTS package that has been migrated from DTS to SSIS. This was the expression by one of the database user at our end. As you may be aware using Package Migration wizard you can migrate the DTS packages to SSIS within SQL Server 2005 version.
The migration will be completed if there are issues, as a best practice you could migrate any package nothing but if the package is complex then better to re-write in SSIS in order to take advantage of features within SQL 2005. As per the BOL it refers:
After migrating packages from Management Studio, connect to the local instance of Integration Services in Object Explorer to see the migrated packages. If you selected SQL Server as the destination, the migrated packages will be visible under the MSDB node. If you selected a file system folder as the destination, right-click the File System node and then select Import Package to display the migrated packages. After you migrate packages from BI Development Studio, the migrated packages are saved to the file system folder that you specified and added to the open project under the SSIS Packages node.
Fair enough, but this is what you see all the times as there are many client installations will not have SQL Server Service Pack2 to the client machines and it differs as per the documentation that is updated in May 2007. So in order to accomplish the task of viewing migrated package you can use Visual Studio 2005 Integration Services (BIDS) where you will find the converted dts pacakages as dtsx. Dts packages will get lost if one starts Migration Wizard from within a db server under legacy node.
For further study and information on DTS to SSIS refer to this Article link.
