QueryInterface for interface DTS.CustomTask failed ....ERROR

[digitor]

I have converted a package script to vb6 to vb.net and it compiles fine. But when I go to run it I get this error. I have checked the

http://www.sqldts.com

site and they stated that I need to upgrade SQL Server with service pack 2. Well mine is upgraded with service pack 3 and its still happening. I have read forum posts with the same problem and they get the similar error when their sql server has SP2 applied. I'm yet to find a solution to this problem - so do you know the answer??

Error I get:

An unhandled exception of type 'System.InvalidCastException' occurred in create DTS Package creater.exe

Additional information: QueryInterface for interface DTS.CustomTask failed.

 

[DebbieChapman]

I have a DTS package in which I need to force a failure, at the moment I've got

Main = DTSTaskExecResult_Success

in my script, I've tried changing that to Faalure, but it doesnt seem to like it, any ideas?

 

[robfoster]

I am experiencing the same isssue. SP3 is installed on my machine and I still get the 'QueryInterface for interface DTS.CustomTask failed' error. Has anyone figured out a resolution?

 

[Becks25Not]

Did anyone ever figure this out? Any help would be greatly appreciated!

Thanks ~Becks

 

[Becks25Not]

Found the answer in another thread after more searching:

thread707-631969

Thank you Anue!!