?
Solved

SQL Server 2008 - Upgrade a 2000 DTS package easiest way?

Posted on 2009-05-16
3
Medium Priority
?
269 Views
Last Modified: 2012-05-07
I have on another server SQL Server 2K and I am now trying to upgrade about 10 DTS packages to the new setup.  I created a BAK file of the database and did a restore and that seems to work fine and then ran update stats on the new database.  How do I get the 10 DTS packages the easiest way to the SQL 2008 box.   I am hoping I don't have to create all new SSIS packages for each one as it has been a while since I messed with SSIS on SQL 05.  Thanks all
0
Comment
Question by:sbornstein2
  • 2
3 Comments
 
LVL 31

Accepted Solution

by:
RiteshShah earned 1000 total points
ID: 24403107
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 1000 total points
ID: 24403281
In order to edit and maintain your DTS (prior to upgrading to SSIS) you can install the Microsoft SQL Server 2000 DTS Designer Components.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24403318
Also, see this link:
http://support.microsoft.com/kb/962874

I contains a fix as well as links to where you can download the components.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
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.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

862 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