DTS with array

• neneco56

  Ten Centuries

  Points: 1232

  More actions

  March 13, 2009 at 6:59 am

  #129702

  I need to do a DTS that query a table and populate an array or something like that, because

  I need one field of that table to send an e-mail to the manager BUT if that table as 100 records I need to send 100 information to him.

  How do I do that? any ideas?

  thanks in advance

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  March 13, 2009 at 2:44 pm

  #959462

  When you query the table you'll get a result set that has multiple rows in it. That can be sent via email to a manager.

  This might help: http://www.sqldts.com/235.aspx