Retreive value from column and store in variable

• lalit-450914

  SSC-Addicted

  Points: 432

  More actions

  October 1, 2007 at 6:52 am

  #125865

  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.

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  October 1, 2007 at 7:18 am

  #737686

  This article might help -

  http://www.sqlis.com/58.aspx

  Tommy

  Follow @sqlscribe