ssis package

• sql Anand

  SSCommitted

  Points: 1597

  More actions

  November 27, 2011 at 11:27 pm

  #246759

  hi

  i am having 3 sub package..when my 1st package run success then only 2nd package will run..now my 1st package having 18rows 2 rows get error..16runs will insert into 1st table..so by using execute package task i am execute this 3 package..so now my 1st package get error rows , i want to stop my execute package task up to 1 st package run then i want to restart that same 1st package..but in check point scenario if package get error means it will restart..but my 1sts package got succeed only

  how to do this in ssis

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 28, 2011 at 12:18 am

  #1413254

  I'm not really sure what you are trying to accomplish.

  You have 3 child packages, which you execute with Execute Package Task.

  And the first package has 2 error rows. Does this package fail or succeed?

  If it fails, what do you want the other 2 packages to do?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP