Hmmm, OK. What about Bulk Insert as an alternative to SSIS and xp_CmdShell?

Thom A (7/21/2016)

---

dhb (7/20/2016)

---

I finally worked around SSIS by using xp_CmdShell in a stored procedure to import the text file and then move it to an archive when finished. It...

Never did get the SSIS package to see the text file. Even tried running as a proxy account. I spent 3 days running down blind alleys trying to get this...

Thom A (7/18/2016)

---

The error would suggest that the file could not be found, rather than the permissions being denied. The name of your file, however, doesn't look correct, there is...

Credentials are OK. I have other SQL jobs that read files (not write) from the same server and directory.

OK, I didn't see an option to check for the presence of the file, so I added a task to rename the file. If the file isn't there, the task...