October 23, 2009 at 2:47 am
Hello I was trying to access DTS packages that were migrated to SQL server 2005. The person who completed the migration has left. However when I try to access the packages on my pc through Management Studio i get the following error:
“Unable to load SQL Server 2000 Data Transformation Services (DTS) 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. (Microsoft.SqlServer.DtsObjectExplorerUI)”
I then try and install the missing components on my pc, and I am told that they are already installed. I have tried this from another pc same result? Any ideas ?
October 23, 2009 at 7:30 am
could anyone help on this ?
December 22, 2009 at 8:46 am
Were you able to solve this? I am in the same boat. The KB fix did not work for me.
December 22, 2009 at 12:28 pm
Since i could not resolve this i had to install SQL 2000 (i did not have 2000 on my box). Still the DTS packages will not open from SQL 2005, but they open fine in SQL 2000
December 22, 2009 at 12:43 pm
Do you have the "Backward Compatibility" and "2005_DTS" add-ons installed ? What service pack of 2005 are you on ?
December 22, 2009 at 12:47 pm
Sp3, and I do have backward compatibility installed
December 24, 2009 at 2:19 am
I had the same problem and just downloaded and installed the components seperately.
Try:-
http://msdn.microsoft.com/en-us/library/aa544774(CS.70).aspx
or
December 24, 2009 at 3:17 am
You need to download and install the 'SQL Server 2000 DTS Designer Components' from the SQL Server 2005 Feature Pack.
Many sites find they need to then also apply the KB917406 fix in order to edit all their packages.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
December 24, 2009 at 3:49 am
Try registering foll. files in the foll. path
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSPkg.dll
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll
then try to open the dts package.
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
July 22, 2010 at 7:28 am
Just in case you are still struggling, I spend a few hours reading all these and many other suggestions, nothing worked for me until I simply uninstalled the backward compatibitilty components (COntrol Panel->Add/remove programs) and than re-installed them followed by DTS designer:
You can get the links above from here: http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Then everything worked a treat!
Good luck!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply