Having a lot of issues with a web application that calls a series of DTS packages in order to perform desired functions. I am coming in new to the issue as actual developer has left the company - as such there may be users / permissions setup which i am not familiar with which has recently changed now causing the issue.
The problem has been narrowed down to a simple file copy across servers. The DTS package uses a connection to a local file and one to a network location. When running the DTS package locally logged on - everything works ok. However when running it via the web application - it does not.
I would imagine this means the DTS is in fact fine and this is a windows server permission problem. However I have tried everything i can think of, from giving full blown permissions, to using a new share name - even using symbolic links as local file copying works fine. However nothing is working.
Recreating the package itself using new connections prompted a different error - unable to connect to the share as authentication failed. I cant see anywhere to put a username in when creating the connections.
Any advise much appreciated as i am running out of ideas. I accept that there is probably a set user running the package from the web application - but i don't know what user this is - and even if i did - surely giving everyone full permissions to the share would cover it?