By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,424 Members | 1,375 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,424 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 16 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 16 '05 #2

P: n/a
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.


Nov 16 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.