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?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...|||Yeah!
No comments:
Post a Comment