Using value from a Variable as Data Source in SSIS

• Sanju-1056904

  Grasshopper

  Points: 22

  More actions

  June 11, 2009 at 4:29 am

  #131749

  Hi Guys,

  I need your help, if someone could provide it...

  Actually, I have added an Execute SQL Task and stored its result set into an Object Type Variable (as like table).

  Now, I want to use this variable as a Data Source in Data Flow Task. is it possible???

  My main purpose is to just send the output first step in a mail (as attachment or in body). Tell me the simplest way to perform this task.

  thanks,

  Sanju

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  June 11, 2009 at 6:04 am

  #1007938

  This is a double post. Your question is answered here.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/