error in comparation

DTS Package Compare 2

error in comparation

Postby rdobrich » Fri Dec 02, 2005 7:28 am

Hi, I just try to compare package on two servers.
The comparation is really fast. Great job on that.

One Package Failed to compare.
I get message:

Invalid class string reported when loading DTS package 'ImportVPN'. A required COM component or custom task is not installed on this system and has not been registered with DTS Compare, or Microsoft ActiveX Data Objects 2.8 Library is not installed. Error code -2147221005.

The package works on both server.
Posts: 40
Joined: Mon Feb 14, 2005 11:43 am

Postby Dan J Archer » Fri Dec 02, 2005 11:25 am

Good morning,

You can get this kind of message if your package contains a custom task which is not installed (registered) on the machine on which you're running DTS Package Compare. The COM component implementing the custom task needs to be registered in order for DTS Package Compare to be able to use it during the comparison.

So the two main options are either to install that component locally to view that package; or to run DTS Package Compare on a machine on which the custom task is registered.

Hope this helps,

All the best,

Dan J Archer
Posts: 81
Joined: Mon Oct 10, 2005 10:15 am
Location: Red Gate Software

Postby rdobrich » Mon Dec 05, 2005 7:32 am

That's true.
I have Analyze service task (sql 2000) in that package on both servers. Analyse service is not install on my computer. I have sql 2005 full instaled, but not sql 2000.

Posts: 40
Joined: Mon Feb 14, 2005 11:43 am

Postby Bart Read » Mon Dec 05, 2005 4:40 pm

Thanks for posting this. That error message needs updating, although it's correct about a required COM component being installed. The rest of it leaves something to be desired though. This will be fixed for the final release.

Thanks again,
Bart Read
Principal Consultant Ltd
Bart Read
Posts: 996
Joined: Thu Mar 31, 2005 10:17 am
Location: Cambridge, UK

Return to DTS Package Compare 2

Who is online

Users browsing this forum: No registered users and 0 guests