DTS on SQL2008

Posted on 2009-12-18
Last Modified: 2012-05-08

I know it is better to move it to SSIS, but I have a few DTS that I need to use right away, is there a way?thx
Question by:mcrmg
    LVL 26

    Expert Comment

    by installing the backward compatibility tools you may call the old dts packages from sql server 2008

    and have a look at the link at msdn

    Author Comment

    I believ I have a 64bits box, when can I locate backward compatibility tools ?  thx
    LVL 26

    Accepted Solution

    you can download it from microsoft site... and install it..

    Author Comment

    doesnot seem to find it....

    if I open my sql2000 with this dts in it, if I change the servername, is there a way that I can run the dts on 2000 but the data is going to 2008, so 2000 serves as a "bridge|"?  thx

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    779 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

    17 Experts available now in Live!

    Get 1:1 Help Now