Hi, I've written a COM object in C# that a DTS package calls via an
Activex Task. I registered it with REGASM. It works just fine when I run
the dts package from within sql server(either within the dts package, or by
right clicking execute) , but when I execute from the dtsrun command either
in a dos window, or in the sql scheduler, I get a dts/vbScript error that
says "File or assembly name not found". (I've tried both dtsrun and
dtsrunUI)

I am executing the package from the same server that it was created on.
I'm logging in with the same NT account that created the package.

Any thoughts on what dtsrun is doing differently??

Thanks
Bill

Do you have the COM object registered on the server? That's where it runs
from when it is scheduled. It is run from you local machine (where it looks
for the COM object) when you run the DTS or right click to run the DTS.

Rick

"Bill Swartz" <wsaharem (AT) yahoo (DOT) com> wrote

Yeah, I mentioned that I was running it on the same server that the package
was created on.. It ran fine there from the within the package..

Anyway.... the answer is... dtsRun for some reason requires the assembly to
be registered with the /codebase option..

Bill


"Rick Gittins" <rgittins (AT) dungarvin (DOT) com> wrote