January 23, 2012 at 11:59 pm
I got a SSIS package which referes to SFTP path to pull zip files for processing. I have the SSIS package scheduled in windows scheduled task using sysadmin account in "Run As" and it's working fine.
Now I want this job tobe moved to SQL Server agent job, so I have imported the job to MSBD and have created the SQl Server agent job.
Issue:
I am able to run the SSIS packge manually from MSBD with out any issues, while when i try to run SSIS thru sql server agent job it's getting struk at SFTP process and job keeps on running with out end so no log available to troubleshoot.
I have tried running the job using SQL Agent Service account and also tried creating a proxy for sysadmin
account and used in "Run As" with out any luck.
Can anyone please suggest why the SQL agent job is get struk and what work around i can try to fix it.
January 24, 2012 at 5:32 am
What error do you get?
My first guess is that it is a permission issue. Maybe you did something wrong when configuring the proxy. Does the sysadmin account have permissions for the SFTP path?
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply