I have a SSIS package that picks up a file in one network location transforms the data and drops off files ready for import in another network location. The package reads a file and writes a new file or overwrites an existing file in another location. The package works as expected from visual studio and when executed manually (double click in explorer). When run from a maintenance plan or scheduled through the SQL server agent job menu the file is always blank. The process will overwrite existing files and create files when no file exists. I believe this indicates it is not a permissions issue.
- Running MSSQL Server 2008r2
- SQL Server Agent is running as NT AUTHORITY\System with privileges provided to the computer$ on the network share.
Any ideas what is going on and why?