for each loop and object value

Question

for each loop and object value

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

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

shayraber14 Grasshopper Points: 15 More actions · Answer 1

managed...
before the 'Data Flow Task' i've created a 'Script Task' which assigned the object's variable to a string and passed it on:
(Dts.Variables["NewStringVar"].Value = string.Format("{0}", Dts.Variables["ObjectIterarionsVar"].Value.ToString());
then, i could assign that new variable ("NewStringVar") to a new derived column .

Shay

Phil Parkin SSC Guru Points: 247183 More actions · Answer 2

This is possible and does not require any scripting, just a technique known as 'recordset shredding'. Take a read here, if you'd like to know more.
It assigns the values to a package variable for each loop iteration, and, of course, you can assign these variables to derived columns in a data flow.