Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    268

    Unanswered: DTS from .NET (C#)?

    I have a C# app that loads and runs a DTS package. It works great on my dev system but when I move it to the production system (which has SQL Server 2000 installed) it doesn't work. As soon as my app runs, it throws the exception:

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

    I've manually done: "regsvr32 dtspkg.dll" which succeeds but doesn't fix the problem.

    Any ideas?

  2. #2
    Join Date
    Oct 2003
    Posts
    268
    Nevermind, I figured it out. DTS is a COM object and .NET generates a glue DLL: "Interop.DTS.dll".

    I just needed to copy this DLL as well as my .exe

    cool...

  3. #3
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    Yeah!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •