SQL Server 2000 DTS Tools Web Download

Hot Topic

Adding a loggin to a server
Object Explorer/Server Explorer Error
How do you edit Derived Column expressions? (I myself use notepad)
SP1 Database Services failed to install
I can not enter non english text in SQL express...
Problems with decrypting columns
Upgrade advisor can not process trace file
Permission within SET VALUES
More SSIS via the web
Different Data Types in Data Source View

SQL Server

Problem with Microsoft.SqlServer.BatchParser.dll on Windows 64-bit
SSIS Access Denied Error
Parent Child Dimension Question
Dynamic field base on parameter
is this possible in SSIS?
How can I restore a database from a UNC?
Query Designer in SQL 2005 Mgmt Studio a let-down?
Help with Case Statement
Invalid length parameter passed to the SUBSTRING function
SSIS DataFlow Performance Issues

SQL Server 2000 DTS Tools Web Download

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

Thanks

Darren


Answer this question

SQL Server 2000 DTS Tools Web Download

  • cstorm

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

  • James - Small Projects

    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



  • vero_

    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.


  • Kenny Vo

    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



  • Doug Svacina

    In case somebody else still experience the same problems...

    I found help at:

    http://support.microsoft.com/kb/917406/en-us

    -duke63

  • VeeBeeginnerr

    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 Error
    Error Source : Microsoft Data Transformation Services (DTS) Package
    Errir Description : The DTS host failed to load or save the package properly.
    <hit ok>
    DTS Designer Error
    The 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.

  • Emir ALTIN

      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

     

  • Limin

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

  • Mr. Les

    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.

  • Venugopal Talapallikotturi

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

    -Doug

  • DmitriyS

    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 compatibility from 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



  • soulz87

  • barkleyr

    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.

  • dude4453169

    Sometimes happen the same and even only appears the arrows. I had a lot of problems with this messing up my Sql2k Entreprise Manager.



  • SQL Server 2000 DTS Tools Web Download
Answer this question