Post reply

for each loop container not taking all the variables

  • May 22, 2015 at 12:08 pm

    #317625

    I have a execute SQL task where i placed the result set of the query in the object variable. It has 2 values.I m trying to pass these values to the for each loop container, which contains a flat file source and the data is being loaded into a destination table. before the destination table, I am trying to do some updates to the incoming data by writing conditions in the derived column. The records with second variable value are getting updated but those with the the first variable value are not getting updated. Any help?

  • May 23, 2015 at 2:32 am

    #1800197

    s.kandepi3 (5/22/2015)

    I have a execute SQL task where i placed the result set of the query in the object variable. It has 2 values.I m trying to pass these values to the for each loop container, which contains a flat file source and the data is being loaded into a destination table. before the destination table, I am trying to do some updates to the incoming data by writing conditions in the derived column. The records with second variable value are getting updated but those with the the first variable value are not getting updated. Any help?

    Quick thought, check the scope of the variables and that a variable with the same name does not exist in a wider scope.

    😎

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

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