In a script task, how to get the steps in a child package?

• qq-522733

  SSC Journeyman

  Points: 97

  More actions

  August 12, 2008 at 1:33 pm

  #211129

  The script task is loading and running the child package. How can I get the steps within the child package? The package object doesn't seem to have this option. Could anyone here help me?

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 12, 2008 at 2:15 pm

  #857034

  It's fairly easy to walk down the package.

  See http://msdn.microsoft.com/en-us/library/ms135946.aspx as a starting point.

  Here are many tips:

  http://mahiways.spaces.live.com/blog/cns!6A1F270FEA8CDD8C!142.entry

  Finally: http://www.google.co.uk/search?hl=en&safe=off&rlz=1T4GZEZ_en-GBGB270GB270&pwst=1&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=programmatically+create+ssis+package&spell=1

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• qq-522733

  SSC Journeyman

  Points: 97

  More actions

  August 13, 2008 at 7:54 am

  #857416

  Thanks Crispin.

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 13, 2008 at 7:56 am

  #857420

  Just a note: You cannot walk down your package from your script task. You need to create an instance of the package in the script task. Sucks a bit.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!