Using 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: