Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-03-22
5
Medium Priority
?
594 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 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

577 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