SSIS - Execute Package Task

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Articles Requested » SSIS - Execute Package Task

SSIS - Execute Package Task

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Tuesday, August 02, 2011 3:30 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:37 PM
Points: 31,521, Visits: 13,855

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1153131

SQLSophist

Posted Wednesday, September 21, 2011 2:40 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 9:00 AM
Points: 27, Visits: 322

I can take this topic.

Post #1178496

Raunak Jhawar

Posted Friday, May 18, 2012 3:57 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

Is this article live on SSC?

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum

Post #1302368

SQLSophist

Posted Friday, May 18, 2012 4:03 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 9:00 AM
Points: 27, Visits: 322

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.

Post #1302371

Steve Jones - SSC Editor

Posted Friday, May 18, 2012 10:25 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:37 PM
Points: 31,521, Visits: 13,855

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"

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1302669

SQLSophist

Posted Monday, May 21, 2012 11:12 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 9:00 AM
Points: 27, Visits: 322

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

Will put something together this week.

Post #1303544

Steve Jones - SSC Editor

Posted Monday, May 21, 2012 11:23 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:37 PM
Points: 31,521, Visits: 13,855

No hurry. We're 4-6 weeks out on publishing now.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1303551

SQLSophist

Posted Monday, May 21, 2012 11:28 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 9:00 AM
Points: 27, Visits: 322

Fine, noted.

Post #1303556

« Prev Topic | Next Topic »

Permissions