Monday, April 12, 2010

DTS in SQL Studio 2008

Download here

1. Download and isntall the latest Microsoft SQL Server 2005 Backward Compatibility Components (It is for 2008 also)
2. Download and install the latest Microsoft SQL Server 2000 DTS Designer Components
3. Try right-clicking on a DTS package and select Open. If you still get the error, follow these steps:
a) 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.
b) Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources\1033 folder to the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033 folder.
(Reference: http://msdn.microsoft.com/en-us/library/ms143755.aspx )