store results into variable

• guru12

  Ten Centuries

  Points: 1068

  More actions

  August 17, 2010 at 8:11 am

  #224875

  Hi Everyone...

  I have one sotred procedure with Tablename,Startdate and enddate.i am executing that procedure using execute sql task,my requirement is to store result into a variable that i can use in dataflowtask.so can any one help me how to do this .very urgent, need some help.

  Regards..
  guru12

• guru12

  Ten Centuries

  Points: 1068

  More actions

  August 17, 2010 at 8:17 am

  #1207899

  Sorry everyone..

  i have a stored procedure like GETALLCHANGESDATETIME with input variables @tablename,@Startdate,@Enddate

  Regards..
  guru12

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  August 17, 2010 at 8:25 am

  #1207909

  What is your result? Is it a result set or just a scalar value?

  John

• guru12

  Ten Centuries

  Points: 1068

  More actions

  August 17, 2010 at 8:41 am

  #1207922

  Hi...

  i want to put all records into a variable,it is resultset.

  Regards..
  guru12

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  August 17, 2010 at 8:46 am

  #1207929

  http://www.lmgtfy.com/?q=execute+sql+task+result+set+into+variable

  Have a look at this, and post back if there's anything you still don't understand.

  John

• jayraj0071

  SSC Journeyman

  Points: 86

  More actions

  August 26, 2010 at 11:24 am

  #1212452

  You need to take a variable which is of Object data type whch stores all the records into variable