Error calling DTS from ASP -
06-01-2006
, 09:45 AM
Hi.
I'm working in a dts package that must be called from asp at the end of
the day, but not all days, so a scheduled execution is unecessary.
The DTS package first set the value for a Global Variable in the pump
tasks and then execute the 4 sql sentence contained in the package.
The problem is that all the task, except for Active X that set the
Variable value, failed.
I believe it's permission issue but i don't know how to solve it.
when i run the dts from the sql manager it runs perfectly, but from the
asp don't
I'm not sure who's the user resonsable for that IWAM? IUSR??
any help will be very helpful.
If there's any log or script that you, please let me know.
PS: sorry if my english it's too bad, i'm from Chile =D |