What I am trying to achieve is run an SSIS package from SQL Server which is on a database server. I have no problems running the SSIS package within visual studio but when I try to run as a SQL job in SQL Server it fails and I get the below message.
I have created a proxy and tried running as a job again but it still fails
Extract CSV File:Error: Cannot open the datafile "Z:\Program Files\Employment Survey\Final ESS Export.csv".
Any Suggestions ?
change it from using the mapped drive "Z" and use the UNC path - first step, I suspect that sql can't map the Z drive
MVDBA
November 28, 2019 at 3:08 pm
That solved the issue, Thanks !!
November 28, 2019 at 3:13 pm
we get so many of these, it might be really cool as an article for people in the same situation as you
MVDBA
November 28, 2019 at 3:51 pm
Yeah I agree, this something really simple that is used a lot, would be handy if it was in article that explains how to set up ssis packages in an environment.
November 28, 2019 at 3:59 pm
Good luck, steve will guide you. he helps me a lot 🙂
MVDBA
November 28, 2019 at 4:26 pm
Thanks !
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply