how to schedule these package in an efficient way

• madhu-686862

  SSChampion

  Points: 10707

  More actions

  April 3, 2008 at 9:47 pm

  #124749

  hi,

  I have like 10 packages of similar type. I want to schedule them by creating one more package n kept these 10 packages in that

  is there any possible way to do schedule only one package,which in turn run all the 10 packages together?

  thank you

• manfred19551

  Old Hand

  Points: 328

  More actions

  April 4, 2008 at 4:30 am

  #798297

  hello,

  you can do this by creating a new package. Then add to this package a "execute package task".

  Configure this (see attachment below)

  After your configuration, run this new package from SQl Server agent as a one job .

  regards

  manfred