Post reply

Call 1st pakage from the 2nd package in SSIS to load the data

  • July 19, 2011 at 12:52 pm

    #241102

    Hi,

    I have two packages:

    1st package gets the data from the csv files to the staging tables

    2nd package gets the data from stagin tables to the target tables.

    I am wondering, what is the best way to design to call the 1st package in the 2nd package to get the data loaded.

    Please throw me some options on this. Your help would be greatly appreciated.

    Thanks,

    Revathi.

  • July 19, 2011 at 1:33 pm

    #1355120

    You can use an Execute Package task in the control flow to execute another package from within a package.

  • July 20, 2011 at 7:14 am

    #1355574

    Thank you very much for reply.

    Is it good if I use sql server agent job and create the steps. Would that work or Execute Package task would work.

    Could you please explain me the steps how to do that using sql server agent job.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply