Goldencharter
asked on
SSIS DTS Package issue - filename specified in the connection was not valid
Hi All,
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?
Regards,
Graham
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?
Regards,
Graham
>When running the DTS package locally logged on - everything works ok. However when running it via the web application - it does not.
The above answer is correct, this is likely a user / privs issue of whatever user is the web application.
btw just to 'check the box', Microsoft is about to retire support for SQL 2005, and DTS is an up-to-2005 technology, so I'd strongly consider upgrading/rewriting these DTS packages as SSIS or something else.
The above answer is correct, this is likely a user / privs issue of whatever user is the web application.
btw just to 'check the box', Microsoft is about to retire support for SQL 2005, and DTS is an up-to-2005 technology, so I'd strongly consider upgrading/rewriting these DTS packages as SSIS or something else.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Issue resolved internally.
While you're there you might want to check the authentication that the web application uses.