Running SSIS through SQL Server Agent

• SatishAyyar

  SSCrazy

  Points: 2825

  More actions

  August 27, 2010 at 1:20 pm

  #148552

  Hi,

  When I run a package in BIDS, one of the task (Execute Process task) will ask for user name and password and after entering, the package runs successfully.

  how to handle this situation when I run this package through SQL Server Agent.

  Thanks for you help

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  August 27, 2010 at 1:38 pm

  #1213221

  In BIDS you can use EPT to run a package, but in SSA, you require to create a JOB to run a package,

  Try creating a job first then , Start that job to run your Package.

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]