SQL Server 2008 R2 installing Design-time Support for DTS Packages

To ensure that the DTS designer can be used in SQL Server Management Studio

  1. Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE folder.
  2. Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources folder to the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id% folder. For example, for U.S. English, the lang_id subfolder will be “1033”.

To ensure that the DTS designer can be used in Business Intelligence Development Studio

  1. Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE folder.
  2. Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources folder to the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\%lang_id% folder. For example, for U.S. English, the lang_id subfolder will be “1033”.

On a 64-bit computer, substitute %ProgramFiles(x86)% for %ProgramFiles% in the following procedures.

Cut and paste in a small CMD file the following statements:

copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\SEMSFC.DLL” “%ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE”
copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\SQLGUI.DLL” “%ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE”
copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\SQLSVC.DLL” “%ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE”

copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\Resources\1033\SEMSFC.RLL” “%ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033”
copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\Resources\1033\SQLGUI.RLL” “%ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033”
copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\Resources\1033\SQLSVC.RLL” “%ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033”

copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\SEMSFC.DLL” “%ProgramFiles(x86)%\Microsoft Visual Studio 9.0\Common7\IDE”
copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\SQLGUI.DLL” “%ProgramFiles(x86)%\Microsoft Visual Studio 9.0\Common7\IDE”
copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\SQLSVC.DLL” “%ProgramFiles(x86)%\Microsoft Visual Studio 9.0\Common7\IDE”

copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\Resources\1033\SEMSFC.RLL” “%ProgramFiles(x86)%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\1033”
copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\Resources\1033\SQLGUI.RLL” “%ProgramFiles(x86)%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\1033”
copy “%ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn\Resources\1033\SQLSVC.RLL” “%ProgramFiles(x86)%\Microsoft Visual Studio 9.0\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: