A shared datasource with SA credentials on a report server.... what's the worst that could happen? 😉

While I understand the simplicity and brevity you were going for ...

Naffmonk, I have been using a batchfile with winscp, but I think I will give your approach a shot now as a script task should in theory give...

I created a batch file that does all the SFTP information using Winscp.... from SSIS I just created a execute process task and point it it to the batch...

I installed SQL 2000 after a 2005 instance, and had no troubles. You will have to use a named instance on one of the installs though.

I am having this exactly problem. I'll post as soon as I figure out my fix for it. I'm going to try to assign the 'datawrite'...