Is the Web Download to install SQL Server 2000 DTS tools available yet? If so where?ThanksDarren

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

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.

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.

The designer download does require MDAC 2.6 sp2 or newer, but you're likely to have that already.-Doug

Can we install the SQL Native Client on a SQL2000 box? would that make any difference to the Management Studio?

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.

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?

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.

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...

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

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?

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

In case somebody else still experience the same problems... I found help at: http://support.microsoft.com/kb/917406/en-us -duke63

Sometimes happen the same and even only appears the arrows. I had a lot of problems with thismessing upmy Sql2k Entreprise Manager.

Hi duke 63, Thanks for your help. It worked. Regards Aravind

Admindba, You are right on the money. I have SQL 2010 r2 and your solution works perfectly.