SSIS execution -
02-11-2009
, 01:31 PM
I think this is due to my lack of understanding of the process. I created an
SSIS package that will export rows from the database to a file on the
network. When I run the package in the Execute Package Utility, it exports
the rows as expected, however when I try to set up a job to execute the same
package I get a cannot connect to file [filename] error. I stopped the agent
service and used my login (I have admin rights) and restarted with the same
result. Am I missing something? Why can I execute the saved SSIS package
from the file system, but not the agent?
John |