SSIS - child parent package

Posted on 2011-10-21
Last Modified: 2012-05-12
Is there a way to call the child package within the data flow task of a parent package after the source is defined and certain transformations are done?

Question by:spirose
    1 Comment
    LVL 18

    Accepted Solution

    No We cannot call a child package from DataFlow Task. You need to use execute package task to call a package.
    The best way for you would be split the transformations in to two data flow task , one has the transformations before the child package is to be executed and other has the rest of logic after the child package is executed.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now