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

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Ollie Riches" <ol**********@phoneanalser.net> wrote in message
news:OL*************@TK2MSFTNGP15.phx.gbl...

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.

[Ollie Riches]

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

Ollie

"Dan Guzman" <gu******@nospam-online.sbcglobal.net> wrote in message
news:#$**************@TK2MSFTNGP14.phx.gbl...

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

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Ollie Riches" <ol**********@phoneanalser.net> wrote in message
news:OL*************@TK2MSFTNGP15.phx.gbl...

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.