JamFisk


I am having trouble executing the example from microsoft that call a DTS package from a web server. I alway get Service Failed.

I have loggin on in the pagage and it doen't get that far. I have set up IUSR_<machine> with access to sql server and granted approiated file permissions. The package loads but fails on execution. I can run the same code as a console app and it works. Any help would greatly appreciated.





Re: Web Services And SSIS

Jamie Thomson


JamFisk wrote:

I am having trouble executing the example from microsoft that call a DTS package from a web server. I alway get Service Failed.

I have loggin on in the pagage and it doen't get that far. I have set up IUSR_<machine> with access to sql server and granted approiated file permissions. The package loads but fails on execution. I can run the same code as a console app and it works. Any help would greatly appreciated.

You say DTS but this is a SSIS forum. Can I clarify whether you asking about DTS or SSIS.

It would help to link to said example as well.

Thanks

Jamie