MS SQL Server DTS - dts / com objects

Author

dts / com objects

Bill Swartz

2005-07-19, 8:24 pm

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

Rick Gittins

2005-07-19, 8:24 pm

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@yahoo.com> wrote in message
news:eHDIN3KjFHA.2772@TK2MSFTNGP12.phx.gbl...
> 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
>

Bill Swartz

2005-07-19, 8:24 pm

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@dungarvin.com> wrote in message
news:%23txlEDLjFHA.2904@tk2msftngp13.phx.gbl...
> 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@yahoo.com> wrote in message
> news:eHDIN3KjFHA.2772@TK2MSFTNGP12.phx.gbl...
>
>

Sponsored Links