Hi

I have a package running to FTP some files to a local folder.

I can run this package ok in Visual Studio Business Intelligence development studio and by running the dtsx package in SQL Server but when I save the package in SSIS store and run it from within SQL server as a job in Job Agent I get a failure.

The error message is

Source: Receive file from TB server FTP Task Description: Directory is not specified in the file connection manager "Local_file_location". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 09:43:46 Finished: 09:43:53 Elapsed: 6.937 seconds. The package execution failed. The step failed.


Any thoughts. Is ther something else I need to do to run a dtsx package as a job.

I think this must be a permission problem.

The job runs ok in the Job Agent if I write to a local drive C:\temp but not if I write to a network drive. But both methods work if I run the dtsx package manually in SQL server.


Thanks

Nick