Solved

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

Posted on 2009-05-16
3
266 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 250 total points
ID: 24403107
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

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 …
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 video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

691 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