December 7, 2010 at 3:45 am
Hello All;
I am going to have a Project to Upgrade from SQL 2000 to 2008. My main issue is DTS Packages. When I run the SQL Upgrade Advisor, many Incompatibility issues come with the following statement:
"Package contains unregistered custom task or Analysis Services Processing task"
Is it Possible to just leave the DTS Packages in Legacy or I should Upgrade to SSIS? Not that familiar with DTS Packages and SSIS but if I get pointers I can be able to do the right thing
December 7, 2010 at 7:06 am
you can continue to run your DTS packages if you download Microsoft SQL Server 2005 Backward Compatibility Components from the SQL2008 feature pack at
That will allow you to continue running DTS packages, but not edit them. For that you would need the DTS designer package. see
http://technet.microsoft.com/en-us/library/ms143755.aspx
If you don't have too many packages I would look to rewrite them in SSIS as part of the upgrade. If there are many and timelines are tight then use the backward compatibility tool and rewrite them after the upgrade, but don't expect this capability to be available in the next version of SQL.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply