?
Solved

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

Posted on 2009-05-16
3
Medium Priority
?
267 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
[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
  • 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
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.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

752 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