Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

DTS SSMS

I am using SSMS 2008 connecting to SQL Server 2000. I can see the installed DTS packages under Management > Legacy.  But I don't seem to be able to open/edit the package.  Do I need to have a licensed version of the client to be to work with the installed packages that were created in Enterprise Manager/SQL Server  ? Someone else mentioned this but I wasn't sure. Thanks for any feedback.
0
fjkaykr11
Asked:
fjkaykr11
1 Solution
 
ValentinoVBI ConsultantCommented:
See How to: Install Support for Data Transformation Services Packages

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

o 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.

o 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

o 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.

o 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".
0
 
fjkaykr11Author Commented:
thanks for the reply. I already had to do those steps to be able to see the DTS packages under the Legacy Container in SSMS.  However, I can't seem to open them and someone else mentioned I need a license.  I heard of need a license to manage DTS SQL Server 2000 via SSMS.  That is what I was looking for information on.  Thanks.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now