DTS runs in Mode Design but no in IIS

[Don Juan]

Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated succesfully.
- When I setup my IIS in the same computer that point to the same directory,
I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.

[unknown]

I do not know much about DTSx but most likely, you have simply a permission
problem here: the windows account used by IIS to run the package is not the
same account as your own when you are running this package interactively.

For example, see the last answer on the following thread:
http://bytes.com/forum/thread658958.html
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

Post by Don Juan
Hi all
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated
succesfully.
- When I setup my IIS in the same computer that point to the same
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded
Thanks for your help.