Solved

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

Posted on 2011-03-22
5
531 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
>>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
Comment Utility
Thank you so much for your help!
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

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 …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

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

12 Experts available now in Live!

Get 1:1 Help Now