I agree with you but right now our structure is more a do it yourselves and you need to make sure that you don't mess up with the data we...

Nick,

Thanks for that as it seems that SQL Agent is only set up for Local System.

I will now need to figure out what the best way to set this up...

I am going to check! I will let you know if it helps.

In fact I am using UNC to access the other drive but this is not the issue I guess.

Hi,

After working around this I think that the issue is with my connection to the folder on the FTPs server.

The external folder has been mapped on the server where SQL...

Good point there - how can I check this?

The account I am using is the same one for all tests (SSIS in VS, dtexec through query and SQL Agent)

The output provided is for the failed job.

When run from SQL Agent I have a "success" for the job - but my files have not been moved!!!

I am moving the files. But everyday I have a new batch to copy and move, etc...

I am testing the package by reposting test files on the ftp folder.

If run...