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.