Friday, November 5, 2010

Open DTS packages in SQL Server 2005...

I am working on a project where in I had to analyse DTS packages and figure out the tables being exoprted/imported. The supported environment i have is only SQL Server 2005 and SQL Server 2008, so i needed way to open up DTS packages in SQL Server 2005. Microsoft has a tool SQLServer2005_DTS available for download in the MSDN site. Once this file is download and installed, one would have the ability to open DTS packages from Management Studio. Looka t the snapshot below:

Once the DTS package is opened, the package open up in the DTS designer of SQL Server 2000. Once the package is open, the DTS package can be exported to a Visual Basic file and open the .vb file in a standard text editor and analyse the contents.