Solved

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

Posted on 2011-03-22
5
569 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
[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
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

759 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