March 6, 2012 at 3:46 pm
MSSQL: 2008R2, Enterprise Edition, 64-bit, 10.50.1617.0
Windows: Windows Server 2008 R2 Datacenter, version 6.1 (build 7601: sp1)
Support for DTS is installed, including the Design-time support as instructed on this page:
http://msdn.microsoft.com/en-us/library/ms143755.aspx
When I save a DTS package from a different 2008 server on this one, I am able to open it with no problems.
When I save a DTS package from a SQL 2000 server, I get the following errors, in order, when I try to open it:
[font="Courier New"]
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: The DTS host failed to load or save the package properly.
The selected package cannot be opened. The DTS Designer has been closed.
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)[/font]
After clicking "Ok" on each of those errors, the package actually does open, but it looks kind of weird - all the arrows (workflow errors and data transformation tasks) are visible, but all other tasks and connections are invisible until I click on them (but they do seem to be "there"). If I try to save the package, I get the first error again (The DTS host failed to load or save the package properly).
Am I missing a step? I believe I have everything installed correctly (including moving the .dll files as it says in the above link). As I mentioned, we have other 2008 servers with DTS packages, but I wasn't involved in moving those so I don't know if there was something else that had to be done besides just saving the packages on the destination server.
March 7, 2012 at 8:16 am
bump
March 7, 2012 at 12:01 pm
Ok, after some searching I found out that I may need a certain version of a certain DLL.
Does anyone know where I can find this:
stardds.dll
version:
2000.80.2151.0, Size 172KB, Date Modified 3/29/2006 5:08AM.
normally found in:
c:\Program Files\Microsoft Sql server\80\Tools\Binn\
April 18, 2012 at 12:35 am
I was just wondering if you have managed to resolve this issue? I have exactly the same problem, where I migrated 20 DTS packages and all but 2 open.
I didn't try replacing the DLL because I figured that if the DLL was incorrect, then I wouldn't be able to open any DTS package. The following site suggests that replacing the DLL is dependant upon the version of comctl32.dll.
January 23, 2014 at 3:11 am
Hi,
I'm facing the same issue with SQL 2008. Please let me know if there is any solution for this.
Thanks,
Phani
January 16, 2015 at 12:48 pm
On the theory a late answer is better than no answer (and since I found this one in my search of the exact same question).
Here are two links with possible answers.
http://support.microsoft.com/kb/917406
The first one is the one that worked for me in this case but I've had to do a number of the steps listed in the second link on other machines.
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]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply