DTS Packages in SQL Server 2005 or 2008 64bit

If you are running SQL server 2005 or 2008 and are on a 64 bit machine and want to view DTS packages in management studio, you will need to do several things. This is a repost of Brian Knight’s blog, mine is just the 64 bit version.

Download the DTS designer components in Feature Package for SQL server 2005 December 2008, even if you have 2008. There are older version of the components so make sure you get the December 2008 version. (SQLServer2005_DTS.msi)

Download the Backward compatibility components from the same site. Make sure you get the 64 bit version (SQLServer2005_BC_x64.msi).

Install them both.

Then use the copy command below to move the files. You will need to save these copy commands in a text file with a .BAT extension. Then run the bat file from inside a command prompt. Run the command prompt as Administrator. Notice these files are in the 32 bit Program files directory(x86). Afterward you will be able to import and open DTS packages in SQL server 2005 and 2008. I ran this on Widows 7 64 bit.

COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\semsfc.dll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\sqlgui.dll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\sqlsvc.dll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\Resources\1033\semsfc.rll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\Resources\1033\sqlgui.rll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033
COPY C:\"Program Files (x86)"\"Microsoft SQL Server"\80\Tools\Binn\Resources\1033\sqlsvc.rll C:\"Program Files (x86)"\"Microsoft SQL Server"\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033