DTS 2000 Package Error(s)

From MS SQL Server Management Studio 2005, I register and connect to MS SQL 2000 (SP4) running on another server. I can see the list of 2000 DTS packages on the other server, but when I try to open them I first get:

Error Source : Microsoft Data Transfformation Services (DTS) Package

Error Description : The DTS host failed to load or save the package properly.

I click the OK button and get:

The selected package cannot be opened. The DTS Desiger has been closed.

I click this OK button and get to now famous:

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 already been to the Feature Pack for Microsoft SQL Server 2005 - November 2005 page and installed the Microsoft SQL Server 2005 Backward Compatibility Components and the Microsoft SQL Server 2000 DTS Designer Components.

Now, the DTS Designer does not close. It stays open. I can see inside the package, but all I see are the transformation lines and the precedence lines. The icons are invisable. If I click on the invisable icons, at the end of the lines, an icon appears. This is not a normal icon. It looks like little windows with a blue border and title bar. Nothing I've seen before. Oh it gets better. If I now double-click the icons, the properties window appear as normal. Looks good... I don't need to change anything. I then press the OK button and get the Task references, like I modified the connection. I do not clear the trasformation. I just click the OK and like magic the connection icon looks at it should. This works on everthing I've tried, except for Execute SQL Task icons. I can save it, but not as the save name. I can open the new saved package. It look and works fine.

So whats up?

I am having the same issues (same errors, etc). DTS Designer 2000 will open a 2000 package that has been saved to a SQL 2005 Server SP1 (9.00.2153.00) in the sysdtspackges table, but will not work with a SQL 2000 Server SP4 (8.00.2185). We are running with all the latest service packs and hotfixes for both environments. As far as I can tell, DTS Designer 2000 is not backward compatible, which is an issue for the 450+ DTS 2000 Packages that cannot be converted to SSIS easily. It appears to me that our DBA team will need to keep both the 2000 and 2005 clients installed to support Legacy systems because of this.|||

Scott5 wrote:

From MS SQL Server Management Studio 2005, I register and connect to MS SQL 2000 (SP4) running on another server. I can see the list of 2000 DTS packages on the other server, but when I try to open them I first get:

Error Source : Microsoft Data Transfformation Services (DTS) Package

Error Description : The DTS host failed to load or save the package properly.

I click the OK button and get:

The selected package cannot be opened. The DTS Desiger has been closed.

I click this OK button and get to now famous:

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 already been to the Feature Pack for Microsoft SQL Server 2005 - November 2005 page and installed the Microsoft SQL Server 2005 Backward Compatibility Components and the Microsoft SQL Server 2000 DTS Designer Components.

Now, the DTS Designer does not close. It stays open. I can see inside the package, but all I see are the transformation lines and the precedence lines. The icons are invisable. If I click on the invisable icons, at the end of the lines, an icon appears. This is not a normal icon. It looks like little windows with a blue border and title bar. Nothing I've seen before. Oh it gets better. If I now double-click the icons, the properties window appear as normal. Looks good... I don't need to change anything. I then press the OK button and get the Task references, like I modified the connection. I do not clear the trasformation. I just click the OK and like magic the connection icon looks at it should. This works on everthing I've tried, except for Execute SQL Task icons. I can save it, but not as the save name. I can open the new saved package. It look and works fine.

So whats up?

Hi, i was getting the same problem until i read http://support.microsoft.com/?kbid=917406

Method 1

Warning The following information contains steps to modify a file. Make sure that you back up the file before you modify it.

1.

Open the SQLInstall:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE folder.
Note SQLInstall is a placeholder for the drive where SQL Server 2005 is installed.

2.

Open the Sqlwb.exe.manifest file in Notepad or in another text editor.

3.

Remove the following lines of code from the Sqlwb.exe.manifest file.

<dependency>
<dependentAssembly>
<assemblyIdentity type="win32" name="Microsoft.Windows.Common-Controls" version="6.0.0.0" processorArchitecture="x86" publicKeyToken="6595b64144ccf1df" language="*"></assemblyIdentity>
</dependentAssembly>
</dependency>

4.

Save the changes, and then exit Notepad or the text editor.

5.

Try to modify the SQL Server 2000 DTS package in SQL Server 2005.

It works for SQL Server Management Studio 2005, but in VS 2005 it doesn't work, you must change also:

devenv.exe.manifest

dexplore.exe.manifest

vsaenv.exe.manifest

VSLauncher.exe.manifest

to make VS 2005 able to open all DTS 2000 packages.

If you still get

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)

try:

1.- Uninstall Microsoft SQL Server 2005 Backward Compatibility Components

2.- Uninstall SQL Server 2000 DTS Designer components

1.- Install Microsoft SQL Server 2005 Backward Compatibility Components

2.- Install SQL Server 2000 DTS Designer components

|||I just finished fixing this issue on my computer.
I am running WinXP with SQL Server 2005 Client tools.
I am connecting to a Win2k server with SQL Server 2000.
I had to do the uninstall first, then reinstall, then file edit.
1. Uninstall Microsoft SQL Server 2005 Backward Compatibility Components
2. Uninstall SQL Server 2000 DTS Designer Components
3. Install Microsoft SQL Server 2005 Backward Compatibility Components
4. Install SQL Server 2000 DTS Designer Components
5. Open the sqlwb.exe.manifest file under [drive]:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE
6. Remove <dependency><dependentAssembly><assemblyIdentity type="win32" name="Microsoft.Windows.Common-Controls" version="6.0.0.0" processorArchitecture="x86" publicKeyToken="6595b64144ccf1df" language="*"></assemblyIdentity></dependentAssembly></dependency>

What a pain in the neck!
|||

Scratch that.

Almost immediately after I got it fixed, it stopped working again.
I checked the file to see if it had been rewritten, but it hadn't.
I closed SQL Management Studio and reopened.
It worked! ?
Now, it just seems to randomly work and not work.
What the heck is going on?

|||

Kerry Wano wrote:

Scratch that.

Almost immediately after I got it fixed, it stopped working again.
I checked the file to see if it had been rewritten, but it hadn't.
I closed SQL Management Studio and reopened.
It worked! ?
Now, it just seems to randomly work and not work.
What the heck is going on?

You might want to take this to the DTS forum as this forum focuses on SSIS.
http://groups.google.com/group/microsoft.public.sqlserver.dts/topics?lnk=srg