MSBI (SSIS/SSRS/SSAS) Online Training

Wednesday, May 11, 2011

SSIS Migration from 2000 (dts) to 2008 (dtsx)


Integration Services provides the DTS Package Migration Wizard for migrating SQL Server 2000 Data Transformation Services (DTS) packages that were created by using the DTS tools and object model.
Not all packages can be migrated completely. For example, some DTS tasks do not map to Integration Services tasks, custom tasks cannot be migrated, and some scripts in ActiveX Script tasks or in data transformations cannot be migrated. For more information, see Migrating Tasks and Known DTS Package Migration Issues.
Packages left in the DTS package format can be used in Integration Services solutions and can also continue to run as stand-alone DTS packages.
Many DTS packages are password-protected. If you migrate these packages, the Package Migration Wizard prompts you for their passwords. You cannot migrate a password-protected package unless you provide the correct password.
SQL Server does not install support for Meta Data Services. The Package Migration Wizard supports Meta Data Services (Repository) packages only if SQL Server 2000, the SQL Server 2000 tools, or the Repository redistributable files are installed on the local computer. When the Repository files are present, the Package Migration Wizard can migrate DTS packages that were saved to Meta Data Services. When the Repository files are not present, the Package Migration Wizard can only migrate DTS packages that were saved to SQL Server or to structured storage files.
You can find some known issues in migration here

http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration/
http://technet.microsoft.com/en-us/library/ms143462.aspx

I have some nice links which describes step by step how to migrate DTS to SSIS 2008.
I hope that will help u goto following urls:

http://www.infosys.com/microsoft/resource-center/DTS-SSIS-2008-migration.pdf

http://weblogs.sqlteam.com/derekc/archive/2008/02/19/60518.aspx

http://wiki.sqlis.com/default.aspx/SQLISWiki/MigrationWizardSteps.html


Downloads:
http://pragmaticworks.com/DTSxChange-vs-MSWizard.pdf

Video link for "how to migrate SQL Server 2000 DTS packages to SQL Server 2008"

http://www.msdev.com/Directory/Description.aspx?eventId=493

1 comment:

Appu said...

Thanks for sharring.