I Have an SSIS package that gets data from a file and saves it on the a folder in C drive on the SQL Server.
Then in another task it rename and moves the file to a staging folder on the server. Finally, it copies the file to another folder on the and other server. bother the moving of the file and the copying is done running batch files trough process task.
This all runs great if I run it in SSIS on the server, or execute the package in SSMS on the server, or by running a sored procedure on the server.
However, if I run this in SSMS from my computer everything runs great except the last step of moving the file to the other server.
I think this is a rights issue of some kind. Like maybe SSMS on my machine does not have write access to the server. Is this possible, what can I do about it?