Hi,
I am transferring data from msaccess to sql2005 using foreach loop. I have a table called Children and a column in it called State.
I want to store the value of the State in a variable in the foreach loop. I am using Dataflowtask to transfer rows from access to sql. what component can i use inside dft to store the value of State in a variable.
Plz its urgent
thanku.