Migration Options
After having run Upgrade Advisor, you can view the report that will tell you whether your package can or cannot be upgraded based on the complexity and the components used in the package. At that time, you need to consider the options available for the DTS 2000 packages you’ve already developed and are still running. Some preconditions will affect your choice of options.
While considering crossing the migration bridge, one thing you need always to bear in mind is that Integration Services is a new software that has been developed from the ground up. Though it has adopted most of the DTS 2000 concepts, it is totally different in usability, operation, and, above all, not all DTS 2000 tasks are available in Integration Services. ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
