Solved

coverting DTS packages to SQL Server 2008

Posted on 2010-11-18
4
521 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
Comment Utility
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
Comment Utility
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
Comment Utility
basaral:

anything free?
0
 
LVL 1

Expert Comment

by:basaral
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

763 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

10 Experts available now in Live!

Get 1:1 Help Now