File or assembly name Interop.DTS, or one of its dependencies, was not found.

[Ollie Riches]

I am trying to execute a DTS via COM according to the KB article

http://support.microsoft.com/?kbid=321525

but I am getting the exception "File or assembly name Interop.DTS, or one of
its dependencies, was not found." which is obviously a file not found
exception. I have sql server 2000 installed locally and I can run the
package from enterprise manager. Anyone got any ideas why I am getting when
I have the correct reference in the c# .net project?

--
Cheers

Ollie Riches
http://www.phoneanalyser.net

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.

 

[Dan Guzman]

Is the Interop.DTS.dll in your application bin folder? This should get
generated when you build your project.

You might also check out the examples at
http://sqldev.net/dts/ExecutePackage.htm

 

[Ollie Riches]

yeap it was noob error, no dll in the bin directory

Ollie