Post reply

Two OleDB Source in DataFlowTask

  • August 10, 2011 at 1:07 am

    #241937

    Hi Pals,

    I have a Data Flow Task which has two OleDb Source. Now I just need to confirm whether the two OleDb Source executes at the same time or a OleDB Source will be executed first and moves to the next one?

  • August 10, 2011 at 8:55 am

    #1366632

    The two sources in the data flow task should be started simultaneously. If you want them to start one after another do this in the control flow. Add two separate data flow tasks each with a single source connection and add a precedence constraint between the two tasks and that will ensure the first starts before the second.

  • August 10, 2011 at 10:50 am

    #1366738

    Hi buddy,

    Thanks for your reply,

    I need two OleDB source in a Data Flow Task has to be executed simultaneously.

  • August 10, 2011 at 11:51 am

    #1366783

    MoganDi (8/10/2011)

    Hi buddy,

    Thanks for your reply,

    I need two OleDB source in a Data Flow Task has to be executed simultaneously.

    They will be executed Simultaneously unless you specify a precedence constraint.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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