Solved

how to convert sql 2000 DTS to sql server 2008

Posted on 2010-11-10
3
639 Views
Last Modified: 2013-11-10
how to convert sql server 2000 to SQL server 2008 DTS?
0
Comment
Question by:Bharat Guru
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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.
Viewers will learn how the fundamental information of how to create a table.

688 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