SSIS package run issue thr sql server agent

• virgo

  Ten Centuries

  Points: 1266

  More actions

  January 23, 2012 at 11:59 pm

  #251795

  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.

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  January 24, 2012 at 5:32 am

  #1437598

  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