Post reply

How to set the condition based on Data flow task?

  • January 2, 2013 at 6:37 am

    #286744

    Hi Friends,

    I have a scenario that i am loading data into a table. After that i am getting the maximum value of the primary key and i will update into a Counter table using Execute SQL task. My need is if the data flow task does not insert any records it should not go to the next joined Execute SQL task. So how can i set the condition?

    please help me friends. Any suggestions would be really appreciated.

    Thanks,
    Charmer

  • January 2, 2013 at 7:02 am

    #1572866

    before each load of data set a variable say (RowsLoaded) to -1 or some arbitrary value then use a rowcount and assign the value to the variable when loading your data and after the load on the control flow use a expression and condition to test for success and the variable being > 0 then action the update.

    hope this helps guide you.

    I know it is not a fully detailed explanation so if you need any more help let me know.

  • January 2, 2013 at 7:43 am

    #1572881

    Terry300577 (1/2/2013)

    before each load of data set a variable say (RowsLoaded) to -1 or some arbitrary value then use a rowcount and assign the value to the variable when loading your data and after the load on the control flow use a expression and condition to test for success and the variable being > 0 then action the update.

    hope this helps guide you.

    I know it is not a fully detailed explanation so if you need any more help let me know.

    Thank you so much Terry...It works 🙂

    Thanks,
    Charmer

  • January 2, 2013 at 8:28 am

    #1572904

    nice one, glad to be of help.

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

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