August 26, 2011 at 12:59 pm
I have a developer who has the development tools for SQL 2008 installed on his machine. He also has the DTS Designer Components installed. This worked great for over a year. Now unexpectedly it has stopped working.
We have tried uninstalling & reinstalling the DTS Designer Components, SQL 2008 and applied SQL 2008 SP1.
Does anyone have any suggestions as to why this would have happened? Or for that matter how to fix it?
Thanks
Kenneth
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
August 26, 2011 at 5:12 pm
August 29, 2011 at 8:53 am
Sorry, I should have posted this initially.
TITLE: Object Explorer
------------------------------
This package cannot be edited.
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.
If the "SQL Server 2000 DTS Designer Components" download is already installed, there might be a problem with the compatibility of icons persisted in this DTS package. See the following KB article for more details: http://support.microsoft.com/kb/917406 (Microsoft.SqlServer.DtsObjectExplorerUI)
------------------------------
BUTTONS:
OK
------------------------------
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
August 29, 2011 at 1:10 pm
Has there recently been any change to evironement variables like the PATH? I remember exact same issue occurred when multiple versions of client tools are installed.... some issue with x64 vs x86 if I 5remember correctly.... Yes- you need to have the 8.0 client tools in the path before the 10.0 tools...
So my path intially looked like this:
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\ and I changed it like this:
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies
and then it worked.
August 29, 2011 at 1:11 pm
NJ-DBA (8/29/2011)
Has there recently been any change to evironement variables like the PATH? I remember exact same issue occurred when multiple versions of client tools are installed.... some issue with x64 vs x86 if I 5remember correctly.... Yes- you need to have the 8.0 client tools in the path before the 10.0 tools...So my path intially looked like this:
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\ and I changed it like this:
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies
and then it worked.
I made the assumption that you acutally have installed the DTS Designer tool and are having this problem... if not, you need to install that.
September 1, 2011 at 7:20 am
The developer with the problem made the change you suggested but still no luck. He did mention that he had tried uninstalling and reinstalling the DTS Designer and that he had gotten an error on the last reinstall. I had him try again and send me the error. It is as follows:
Module C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsui.dll failed to register.
HRESULT -2147024714. Contact your support personnel.
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
September 1, 2011 at 7:28 am
manually register the .dll's- any difference?
September 1, 2011 at 7:56 am
When he tried to register it manually he got no error, but no success message either.
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
September 1, 2011 at 1:28 pm
I'm sure it's not the answer you want to hear, but in your shoes, I'd consider starting over with the client... uninstall and resinstall everything, including sql server components... maybe wipe and reimage the machine if that's a reasonable proposition. seems like the install is just all fouled up.
I would then carefully review http://msdn.microsoft.com/en-us/library/ms143755.aspx
September 1, 2011 at 1:29 pm
NJ-DBA (9/1/2011)
I'm sure it's not the answer you want to hear, but in your shoes, I'd consider starting over with the client... uninstall and resinstall everything, including sql server components... maybe wipe and reimage the machine if that's a reasonable proposition. seems like the install is just all fouled up.I would then carefully review http://msdn.microsoft.com/en-us/library/ms143755.aspx
especially this part:
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".
September 1, 2011 at 6:58 pm
1. Install SQL Server 2000 DTS Designer Components
2. Install SQL Server 2005 Backward Compatibility Components
3. Copy these files
(a) On a 64-bit computer, substitute %ProgramFiles(x86)% for %ProgramFiles% in the following procedures.
(b) For U.S. English, the lang_id subfolder will be "1033"
(c) Create the Resources subfolder if it doesn’t exist
DLL files to copy: SEMSFC.DLL, SQLGUI.DLL and SQLSVC.DLL
Source folder
(1) %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn
Destination folder
(1) %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
(2) %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE
RLL files to copy: SEMSFC.RLL, SQLGUI.RLL and SQLSVC.RLL
Source folder
(1) %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources\%lang_id%
Destination folder
(1) %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id%
(2) %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\%lang_id%
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply