Extract CSV File Error : Cannot open the datafile
-
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
-
That solved the issue, Thanks !!
-
we get so many of these, it might be really cool as an article for people in the same situation as you
MVDBA
-
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.
-
Good luck, steve will guide you. he helps me a lot
MVDBA
-
Thanks !
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply