I have a variable of Data Type 'Object'. I populate this with 1 row of data via an Execute SQL Task control, because I have a For Each Loop Container around this Execute SQL task control that gets 1 ID at a time. What I want to do is
now that I have the row of data in my variable object, is update my table with the new data.
I am thinking I need to start with a Data Flow Task? But I'm not sure how/what to use to reference my variable so that I can map it to my destination.
View Complete Post