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

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.
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" <ollie.riches@.phoneanalser.net> wrote in message
news:OLP4UckJFHA.588@.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.
>
|||yeap it was noob error, no dll in the bin directory
Ollie
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:#$jJFpkJFHA.2136@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> 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" <ollie.riches@.phoneanalser.net> wrote in message
> news:OLP4UckJFHA.588@.TK2MSFTNGP15.phx.gbl...
one[vbcol=seagreen]
programmer
>