I have a SSIS project with two tasks in it. A back up database task and a file system task.
The back up database task backs up a database to a network folder.
The file system task is then supposed to make a copy of the backup file in the same folder.
The backup works but the file system task fails with the error in the title.
This is obviously a permissions problem but I'm perplexed as to why the first task succeeds and the second fails when they both involve the same folder.
I'm running the package in BIDS
I have administrative rights on both the server and the development machine BIDS is on.
I've tried running BIDS as administrator with the same results.
If I try copying the file to another folder on the server it fails.
If I try copying the file to the C: drive of the development machine it succeeds.
Any suggestions would be greatly appreciated.