Executing SSIS Packages Manually

• Krishh

  Ten Centuries

  Points: 1088

  More actions

  July 9, 2015 at 12:24 am

  #319649

  Hi Folks,

  I have near about 120 Packages in Integration Services Catalog.

  So, now i need to run all the packages at one shot manually.

  I'm able to do execute a single package but can't go with multiple packages.

  Can you please help me out to do this ?

• Phil Parkin

  SSC Guru

  Points: 246992

  More actions

  July 9, 2015 at 12:31 am

  #1811183

  You can execute SSIS packages from SQL scripts (see here for more info).

  So you can script the execution fairly easily.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel