dbTalk Databases Forums  

Error calling DTS from ASP

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error calling DTS from ASP in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Eclectic
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.