July 1, 2010 at 10:03 am
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.
July 1, 2010 at 10:18 am
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
July 6, 2010 at 4:10 am
Why not just set it up manually in SSIS? It will probably be faster if it's only a simple package...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply