I've set up a simple task which copy data from a table and export them to another database that is on a different server. I have the radio button on to "Delete rows in destination table". I notice the job fails with the error "You don't have Permissions to delete/truncate this table". I had created the task under the sa account as well as my account which is an administrator account. Should I (the task) be able to delete the data in the destination table?