Solved

Replace functionality of complex Data Transformation task encapsulated in Execute DTS 2000 Package task after package migration

Posted on 2011-03-22
5
543 Views
Last Modified: 2012-05-11
Hello,
We are preparing to install SQL2008 side by side with our SQL2000. I ran the Analyzer wizard and it gave me some errors, mostly on our DTS Packages. I am concerned about the following Errors.

Replace functionality of complex Data Transformation task encapsulated in Execute DTS 2000 Package task after package migration

Replace functionality of Dynamic Properties task after package migration

Rewrite ActiveX script code that accesses the DTS object model after package migration

SQL Server 2000 Data Transformation Services is deprecated

My fear is I do the Side by Side and then move the Databases that I need moved over to SQL 2008 and import my DTS Packages we need to run on those Databases and they don't migrate over due to the above errors.

I think I am way over my head on this one.
0
Comment
Question by:Rmumpower00
  • 3
  • 2
5 Comments
 

Author Comment

by:Rmumpower00
ID: 35193923
Let's say for instance I do the Side by Side install and I JUST So happen to do something wrong where my SQL2000 isn't running. Could I uninstall SQL2008 and all will be fine?
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35194915
Do not even attempt to migrate your DTS Packages they will not migrate.  Here are your options:
1.  Convert them to SSIS packages.
2.  Continue to execute them as DTS Packages.

Pick your poison.
0
 

Author Comment

by:Rmumpower00
ID: 35197813
How do I convert them to SSIS Packages and would they function the same after they were converted?

How do I continue to execute them as DTS Packages after the SQL 2008 Install?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 35198373
>>How do I convert them to SSIS Packages and would they function the same after they were converted?<<
You would need to re-analyze and re-write for SSIS.

>>How do I continue to execute them as DTS Packages after the SQL 2008 Install? <<
See here:
Support for SQL Server 2000 DTS in SQL Server 2008 R2
http://msdn.microsoft.com/en-us/library/bb500440.aspx
0
 

Author Closing Comment

by:Rmumpower00
ID: 35198929
Thank you so much for your help!
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

919 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

16 Experts available now in Live!

Get 1:1 Help Now