DTS to SSIS 2008 Migration

• sharath.chalamgari

  SSCertifiable

  Points: 5680

  More actions

  July 1, 2010 at 10:03 am

  #223473

  Hi

  i am migrating from a dts Package to sql server 2008 using BIDS Migration Wizard and i am getting the following error

  "The Package Migration Wizard Requires the sql server 2000 Data Transformation Services runtime. To Install the DTS runtime,run the sql server Installation Wizard.On the Components To Install Page,Click Advanced,then select Legacy Components for installation."

  Actually i have Installed the

  Microsoft SQL Server 2005 Backward compatibility

  SQL Server 2000 DTS Designer Components

  but still facing the issue..

  any solution to it is highly appreciated.

  My DTS Package does not have any complex components or any activxscript components, it just loads the data from flat file to database.

  Can any body is also tells me where these BackwardCompatability components are installed.

• Ashwani Malik

  Ten Centuries

  Points: 1140

  More actions

  July 1, 2010 at 10:18 am

  #1187776

  You need to install few DLL's to make it work.Follow the steps in this link

  http://msdn.microsoft.com/en-us/library/ms143755.aspx

  Thanks,

  Ashwani

• David Sorauer

  SSCrazy

  Points: 2874

  More actions

  July 6, 2010 at 4:10 am

  #1189000

  Why not just set it up manually in SSIS? It will probably be faster if it's only a simple package...