Home > SQL SSIS > DTS Package migration steps from SQL 2000 to SQL2008

DTS Package migration steps from SQL 2000 to SQL2008


  1. Run time support installation for DTS packages.
  2. Design time support installation for DTS packages.
  3. Configure SSMS for DTS packages.
  4. Migrate the DTS packages by using SSMS.These are all high level steps which includes below step by step activities.
  • Check the backward compatibilities and integration services are installed on target server or not.Check the integration service is there or not.
  • Run services.msc
  • If the above services are not installed, go to binaries location and run the Setup on SQL2008 instance on target server and go to the feature selection page.
  • Select both features in the installation wizard and proceed with installation.
  • Download the design time components from the below URL and install the same.
  • http://www.microsoft.com/en-us/download/details.aspx?id=11988
  • Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles(x86)%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles(x86)%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE folder.
  • Download and install SQL upgrade advisor to analyze the existing packages for migration issues.
  • Start the migration package wizard from SSMS to do the DTS package migration.                 Upgrade Advisor: http://www.microsoft.com/en-in/download/details.aspx?id=11455
  • Design time Components: http://www.microsoft.com/en-us/download/details.aspx?id=11988
  • Required Software Download location:
Advertisements
Categories: SQL SSIS
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: