Solved

how to convert sql 2000 DTS to sql server 2008

Posted on 2010-11-10
3
633 Views
Last Modified: 2013-11-10
how to convert sql server 2000 to SQL server 2008 DTS?
0
Comment
Question by:Bharat Guru
3 Comments
 
LVL 18

Expert Comment

by:lludden
ID: 34105183
There is legacy support for DTS in SQL 2008, but the preferred method is to upgrade to Integration Services.
See

http://msdn.microsoft.com/en-us/library/cc768544%28SQL.100%29.aspx
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 50 total points
ID: 34128221
You would need to install some add-on packages like support for SQL2005

Look for : Microsoft SQL Server 2005 Backward Compatibility Components
In the Features Pack downloads : http://www.microsoft.com/downloads/en/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en


Otherwise you will need to convert / rewrite in SSIS
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 34131806
I strongly recommend to re-write your OLD DTS packages in SSIS,
because there are MAJOR differences in SSIS, and you can use lots of Tasks and transformations which you didn't have in old DTS.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

744 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

16 Experts available now in Live!

Get 1:1 Help Now