Sunday, February 26, 2012

DTS2000 error

Hi
When I try to use DTS 2000 Packages in SQL2005 CTP I obtain this error:

Could not load file or assembly 'Microsoft.SqlServer.Dts80, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Impossibile trovare il file specificato. (Microsoft.SqlServer.DtsObjectExplorerUI)

Anyone can help me?

ThanksWhich CTP version are you using?

Look in your DTS\binn folder (by default this is at "C:\program files\Microsoft SQL Server\90\DTS\Binn") and see if there are any files of the names "Microsoft.SQLServer.DTS8*.dll"

I don't have "Microsoft.SqlServer.Dts80.dll" but I do have "Microsoft.SQLServer.DTS8HelperObjectModel.dll", "Microsoft.SQLServer.DTS8HelperUtility.dll" & "Microsoft.SQLServer.Exec80PackageUtil.dll"

and in "C:\program files\Microsoft SQL Server\90\DTS\Tasks" I have "Microsoft.SQLServer.Exec80PackageTask.dll".

Do you have these files, or similarly named files, on your system?

I am on the June CTP by the way. All of these files are version number 9.0.1187.0 which leads me to think that you may be on an earlier version.
You have the choice of whether to install the DTS2000 runtime or not when you install SSIS. Do you remember if you chose to install it?

-Jamie

No comments:

Post a Comment