File not uploading
Hi,
I have a ssis package that uses the execute process task to run a script to upload a file using winscp. The problem is when it runs and I am not remoted into the server it doesn't work. If I remote into the server and run the job it works fine. Why do I need to be remoted in for it to work? I have another job that does the same thing but uploads to a different server every morning without me being remoted in. They both use the same account. The only difference is the job that works uses a private key. The other job just passes in the credentials in the script file using the open command.
I have a ssis package that uses the execute process task to run a script to upload a file using winscp. The problem is when it runs and I am not remoted into the server it doesn't work. If I remote into the server and run the job it works fine. Why do I need to be remoted in for it to work? I have another job that does the same thing but uploads to a different server every morning without me being remoted in. They both use the same account. The only difference is the job that works uses a private key. The other job just passes in the credentials in the script file using the open command.