DTS Packages and SQL Server 2005 Express Version

Posted on 2006-05-07
Last Modified: 2013-11-30
Hello Experts,

Can anyone tell me how to open an existing SQL 2000 DTS package in SQL Express 2005? If I can't open them can I at least run them against an instance?


Question by:JackW9653
    LVL 9

    Accepted Solution

    Support for SQL Server 2000 DTS Packages in SQL Server 2005 Express Edition

    SQL Server 2005 Express Edition does not include Integration Services or support for SQL Server 2000 DTS packages.

    To run existing DTS packages on a SQL Server 2005 Express Edition server, you must leave the SQL Server 2000 client tools or the DTS redistributable files on the server, or reinstall them. SQL Server 2005 Express Edition does not include the DTS runtime.

    To edit existing DTS packages on a SQL Server 2005 Express Edition server, you must use SQL Server 2000, or edit the packages remotely from a server running SQL Server 2005 Workgroup, Standard, Enterprise, or Developer Edition. SQL Server 2005 Express Edition does not include SQL Server Management Studio or BI Development Studio.

    To migrate existing DTS packages to SQL Server 2005 Integration Services, you must use SQL Server 2005 Standard, Enterprise, or Developer Edition. Other SQL Server 2005 editions do not include the Integration Services Package Migration Wizard.

    The Import and Export Utility that is included with SQL Server 2005 Express Edition is not the SQL Server Import and Export Wizard and does not use Integration Services.
    LVL 9

    Expert Comment

    text taken from:

    hope this helps,

    Author Comment

    Thanks for the information Nito. I have 8 SQL 2000 DTS packages that handle importing and exporting to our core application from an external application. We have been requiring customers to purchase a server with Small Biz Server 2003 Premium (with SQL Server 2000) and a workstation that access the SQL table for reporting functions. We were hopeful that for some of our smaller customers that we could cut the hardware costs in half by putting everything on a high powered XP Pro workstation and use SQL Express. But if I understand what I read in the article that cant be done with the 2005 Express Edition. The DTS packages do not need be designed in Express, but they need to be bundled with the database. Any ideas?  
    LVL 9

    Expert Comment

    You could develop stored procedures to do your export/import of the data. Not sure how complex your DTS's are but if you're doing simple copy data from you table to the other you can easily run do the same steps with SQL

    INSERT INTO server.database.dbo.table1
    FROM server1.database.dbo.table1

    Hope this helps.

    Author Comment

    The DTS are fairly complex, the data is coming from a remote UNIX via FTP in various comma delimited files and delineated with the 5th character in the filename. Application logic determines which package is called and then an acknowledgement file is sent back to the UNIX and log files are created. All of this is bundled into the DTS package and some triggers on the tables. So rewriting all of that is pretty much out of the question. Thanks for all of your help. Do you know if DTS packages get saved with a database during a backup?

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now