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
GoldencharterAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jose TorresCertified Database AdministratorCommented:
Just a shot in the dark.  Did you check the application pool identity which the web application runs under.
While you're there you might want to check the authentication that the web application uses.
Jim HornMicrosoft SQL Server Data DudeCommented:
>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.
GoldencharterAuthor Commented:
Hi Guys,
Found the solution in the end to be the server exceeded maximum share connections. All permissions were correct and everything performing fine.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GoldencharterAuthor Commented:
Issue resolved internally.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Applications

From novice to tech pro — start learning today.