SQL Server 2000 DTS Tools Web Download
Is the Web Download to install SQL Server 2000 DTS tools available yet? If so where?ThanksDarren
November 4th, 2005 1:04am
If I answer my own question, at least I'll get one right.SQL 2000 DTS tools are now available as part of the -Download details: Feature Pack for SQL Server 2005 Nov 2005(http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)The direct link to the MSI-http://www.microsoft.com/downloads/info.aspx?na=46&p=16&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f4%2f4%2fd%2f44dbde61-b385-4fc2-a67d-48053b8f9fad%2fSQLServer2005_DTS.msi&oRef=http%3a%2f%2fforums.microsoft.com%2fMSDN%2fShowPost.aspx%3fPostID%3d126513%26SiteID%3d1
November 7th, 2005 7:42pm
I have downloaded the dts tools and when I try to edit a dts package on a SQL2000 instance using the new SQL Server Management Studio, I still get the following errors:Package ErrorError Source : Microsoft Data Transformation Services (DTS) PackageErrir Description : The DTS host failed to load or save the package properly.<hit ok>DTS Designer ErrorThe selected package cannot be opened. The DTS Designer has been closed.<hit ok>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)<hit ok>it takes me to the dts designer (it doesn't close it like it says) and all of the icons in the workspace look like a default windows form icon. I can click on each of them to get the properties, transformations, etc. But I dare not save them. Any idea how to fix this? Or am I not supposed to be able to manage SQL 2000 instances with this tool.
November 17th, 2005 11:28pm
I'm experiencing the very same problem. It occurs even if you right-click on Data Transformation Services and select Open package file..., so it's not a server instance issue. Perhaps it requires the latest MDAC and/or SQL Server Native Client to be installed on the accessed server? Feels a bit buggy to me.
November 24th, 2005 2:05pm
The designer download does require MDAC 2.6 sp2 or newer, but you're likely to have that already.-Doug
November 26th, 2005 8:13pm
Can we install the SQL Native Client on a SQL2000 box? would that make any difference to the Management Studio?
November 29th, 2005 5:26pm
You can install SNAC on SQL 2000 machines, after all that is what happens in side by side installations of SQL 2000 and SQL2005, but it is not requrired for DTS. I can happily edit most 2000 packages (through the web download designer) on a clean SQL 2005 machine, pointing at an existing SQL 2000 instance. Sometimes I get invalid class string errors, since the SQL 2005 machine lacks some custom tasks I used with DTS. I do sometimes get a similar error to you, but haven't got around to seeing which components are used in a good package and a problem package. I suspect there may be a problem task. AS processing tasks gave some problems, but I skipped around it and haven't had time to work it yet.
November 29th, 2005 6:51pm
After uninstalling the entire CTP (including the beta .NET framework) and reinstalling SQL 2005 enterprise I also downloaded and installed the S2k DTS designer web pack.Now I can't create or save DTS packages in SQL 2000 without getting the same error. In SQL 2005 using the legacy designer I get mixed results. So I created a new and very simple DTS package on a different (and clean) SQL 2000 machine that has never had SQL 2005 components installed. It worked fine on the SQL 2000 machine. But when I try to open it using the SQL 2005 designer that I downloaded I get the same annoying error. HOWEVER, certain older packages from that same clean SQL 2000 server CAN be edited and saved using the SQL 2005 designer.This is WAY buggy. Am I missing a download? What about the backwards-compatible pack I saw with all of the (daunting) SQL 2005 downloads? Is there a sequence to doing this? Do I need to fully uninstall all SQL 2000 components first? Can I then reinstall them?
December 7th, 2005 10:54pm
I'm having the same problem. I never had SQL Server 2000 installed, I installed SQL Server 2005 & Visual Studio 2005, then the SQL Server 2000 DTS Designer Component package, but still get error message to install component when trying to open SQL Server 2000 DTS package. I unintalled SQL Server 2005, then installed SQL Server 2000, ran Enterprise Manager ok, then installed SQL Server 2005, and then SQL 2000 Enterprise Manager will not run now, then installed DTS Component package, and still get same error message to install component when trying to open SQL Server 2000 DTS package. Tom E.
December 16th, 2005 8:10pm
I get exactly the same errors and here's what I found... After trying to migrate a DTS package that failed to open I got a somewhat more informative error message out of the report. It stated that the package name cannot contain any of the following characters: / \ : [ ] . =. It so happens many of my packages have ':', '.' in the names and so apparently they have changed this aspect as well (thanks Bill for the lack of documentation). Anyhow, after renaming the packages I was able to open them (still with errors but it worked) and migrate them. What a pain in the a**!!! Hope this helps...
January 17th, 2006 7:22pm
I was also having same problem error message was 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) The resolution First download and install SQLServer2005_BC component for backward compatibilityfrom microsoft Then Install SQLServer2005_DTS component. http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en) It should work.In my case it was successfully leting me edit DTS package developed in SQL Server 2000 version Thankx
February 9th, 2006 12:18pm
So what is the correct anwer here. It looks like it works for some but not for others. I happen to be one of the others that this does not work for. I've been working with a new box, clean install of the latest and greatest. ( a number of times, by the way. ) Sorry, but this is driving me nuts. Microsoft Support where are you?
April 3rd, 2006 11:43pm
Scott, There is no documented resolution from Microsoft that these forums will be frequented by MS staff. You should seek support via your MSDN subscription and then PSS as far as I know. -Jamie
April 3rd, 2006 11:50pm
In case somebody else still experience the same problems... I found help at: http://support.microsoft.com/kb/917406/en-us -duke63
December 12th, 2006 3:13pm
Sometimes happen the same and even only appears the arrows. I had a lot of problems with thismessing upmy Sql2k Entreprise Manager.
December 12th, 2006 4:12pm
Hi duke 63, Thanks for your help. It worked. Regards Aravind
January 23rd, 2007 5:29pm
Admindba, You are right on the money. I have SQL 2010 r2 and your solution works perfectly.
December 17th, 2010 12:38pm