Solved

coverting DTS packages to SQL Server 2008

Posted on 2010-11-18
4
522 Views
Last Modified: 2012-05-10
I have various DTS package which I used to use when we were on SQL server 2000.

How can I convert those so they can be used in SQL 2008
0
Comment
Question by:CalmSoul
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
basaral earned 250 total points
ID: 34167784
You can migrate DTS packages into SSIS.  Check out:
http://msdn.microsoft.com/en-us/library/cc768544(SQL.100).aspx
0
 
LVL 7

Assisted Solution

by:Cboudroz
Cboudroz earned 250 total points
ID: 34167808
you can run the DTS on SQL server 2008, if you don't want to convert them.

http://msdn.microsoft.com/en-us/library/bb500440.aspx

some DTS tool will need to be install.
 
0
 
LVL 5

Author Comment

by:CalmSoul
ID: 34168067
basaral:

anything free?
0
 
LVL 1

Expert Comment

by:basaral
ID: 34168522
Below is the method I've used.  To be honest, I haven't worked with or searched for any 3rd party solutions.

With an Integration Services project open in Business Intelligence Development Studio (BIDS), right-click the Packages folder and select Migrate DTS 2000 Packages to launch the DTS Package Migration Wizard. Once launched, the wizard will quickly walk you through a migration process which can migrate most DTS tasks. The migrated packages will be added to the Integration Services project that is currently open. You can also start the DTS Package Migration Wizard from SQL Server Management Studio or from the command prompt.


0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

863 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

20 Experts available now in Live!

Get 1:1 Help Now