Avatar of beroscoe
beroscoe asked on

Executing SSIS from Web Serivce

I have an SSIS package with takes a file, changes the format and then saves it to a local drive. It then takes this file and compares it to a databse to try and find matches. Now I want to be able to run this via a web service so I have created the service.

It can connect to the package fine, and begin the execution of the package but when it comes to dump the files out I am getting errors. Thing like:

Cannot open the datafile "[FilePath]\outputnotinadtec.csv".
component "not in adtec" (16) failed the pre-execute phase and returned error code 0xC020200E.

I can't find anything useful on this problem. I am thinking it is access rights so I have everyone full control over the top most directory (it should filter down) but it is still giving me this error. Its running under the user who submits the information. Am i missing an account which SSIS uses to run the items????

Any help would be apreciated.
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
PedroCGD

8/22/2022 - Mon
PedroCGD

dear friend,
Where is the CSV file?!
In the webservice server or SQL 2005/SSIS 2005 server?!
Cheers!
ASKER
beroscoe

its on the webservice server so as to make sure that it is not trying to communicate accross servers.
ASKER CERTIFIED SOLUTION
PedroCGD

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
beroscoe

Sorted it now. I gave up on the idea, What I have done is to create a web service and call the package via the sql server agent, makes it easier and works like a dream.

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
PedroCGD

Good!!!!!!!!!!!!!!!!
If you have more doubts tell me or send me an email!
Cheers!
PedroCGD

close this topic!
Cheers!