Solved

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

Posted on 2011-03-22
5
560 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

821 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