April 18, 2012 at 10:08 am
Hi,
I have to establish a VPN connection to a remote server first, then connect SFTP to transfer files from there. I am able to connect the VPN in SSIS package and execute it manually. But when I am schduling as SQL Agent Job, the job keeps on running without success/ failure (i.e) job is not establishing a connection.
I have searched in forums, googled but still in vain. Could you please tell me how to solve the problem?
April 19, 2012 at 12:54 am
suresh.arumugham (4/18/2012)
Hi,I have to establish a VPN connection to a remote server first, then connect SFTP to transfer files from there. I am able to connect the VPN in SSIS package and execute it manually. But when I am schduling as SQL Agent Job, the job keeps on running without success/ failure (i.e) job is not establishing a connection.
I have searched in forums, googled but still in vain. Could you please tell me how to solve the problem?
Does the SQL Server Agent user account has the necessary permissions?
Can you shed some light on how you established the VPN connection? Someone in another forum is currently struggling with this.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply