June 2, 2009 at 12:09 pm
I have been using DTS packages since Sql Server 2000 and have pushed them forward to Sql Server 2005 and then to Sql Server 2008. The packages are executed within a job and run just fine. Now I need to modify one of these packages and when I try and "Open" the package I get the following Error :
SQL Server 2000 DTS Designer components are required to edit DTS packages.
Install the special Web download, "SQL Server 2000 DTS Designer Components"
to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
I have scoured the net and tried every article I have read, here is what I have done.
Step 1. Installed SQLServer2005_BC*.msi
Step 2. Installed Microsoft SQL Server 2000 DTS Designer Components.
Step 3. Copied files
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.
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".
I still get the error above. I am trying to get this to work on my desktop using the client tools from Sql Server 2008 Enterprise edition. My OS is Vista...
I also tried to edit a SSIS package that mirrors the DTS package but when I run the upgrade from 2005 to 2008 it gives me a password error (even though I don't have one) so I am unable to get to either. I prefer to get the DTS working and then create a new SSIS package within Bids 2008 and skip the upgrade process.
Any help with this would be greatly appreciated...
June 2, 2009 at 2:12 pm
I have continued to work on this problem and found a few more interesting tidbits. A co-worker was also having issues with editing DTS packages and decided to load the Backwards Compatibility file mentioned in several articles but he used the file (SQLServer2005_BC.msi) from disk rather than using a download from the net. When this is done the DTS Package can be edited but several error messages pop up. These errors do not seem to affect editing the package...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply