SQLServerCentral

SSIS - Execute Package Task


https://www.sqlservercentral.com/Forums/Topic1153131.aspx

By Steve Jones - SSC Editor - Tuesday, August 2, 2011 8:30 AM

Can someone write a basic article that explains how the Execute Package is used to run a child package or string together multiple packages in SSIS. Please include screen shots of the configuration and explain the options that are possible.
By arapaima_uk - Tuesday, September 20, 2011 7:40 PM

I can take this topic.
By Raunak Jhawar - Thursday, May 17, 2012 8:57 PM

Is this article live on SSC?
By arapaima_uk - Thursday, May 17, 2012 9:03 PM

Well, the pinned post said the topic would be assigned to me, which never happened.

Do you have a particular problem with the exec package task I can help with? If so, suggest raising in the main forum and posting a link here.
By Steve Jones - SSC Editor - Friday, May 18, 2012 3:25 AM

Sorry, SQLSophist, this slipped through the cracks.

Please take it if you want.

How about two child packages that do
- load a simple file (assume an Excel file, simple format, same name, just a data transform load)
- send an email that a load was completed.

Those could be tasks, but for the sake of this article, make them separate packages. Then show a parent package that executes these two in that order. Explain how any parameters/configs with the child execution are handled. If you want, include a "we only execute #2 if #1 succeeds"
By Steve Jones - SSC Editor - Monday, May 21, 2012 4:23 AM

No hurry. We're 4-6 weeks out on publishing now.
By Steve Jones - SSC Editor - Monday, May 29, 2017 1:14 AM

tychopotts - Saturday, May 27, 2017 9:21 AM
If you're still looking for articles for this topic, I'd like to take a stab at it. Can you assign this to me?


Take it. I don't see one in the list.
By arapaima_uk - Monday, May 21, 2012 4:28 AM

Fine, noted.
By arapaima_uk - Monday, May 21, 2012 4:12 AM

OK, great. I've been away watching cricket since your post, but back in the "SQL Saddle" now.

Will put something together this week.
By tychopotts - Saturday, May 27, 2017 2:21 AM

If you're still looking for articles for this topic, I'd like to take a stab at it. Can you assign this to me?
By tychopotts - Wednesday, May 31, 2017 1:48 AM

Thanks for the opportunity. I've submitted my draft for review.