create a job which send email with attachment of excel to multiple users

• niravbhat

  SSC-Addicted

  Points: 416

  More actions

  August 5, 2011 at 1:52 pm

  #390135

  I have to work on certain project , I have attach file for your references. please guide me

  I have following column in one table

  OwnerName, Name, InFolder, Modified

  example

  you can see ownerName = 'AAchenkunju' , this guys have almost 55 rows ( means differnts file) in the table.

  Like this there are several OwnerName(588) are in the Table having several file(row)

  My question is,

  If you want to send an email to each OwnerName with only his file records with attaching an Excel file.

  How can we do that? and what SSIS package and transformation you have to used ?

  How to create that loop, and what kind of variable I have to use?

  Thanks in Advanced

• 1Ankit1

  Ten Centuries

  Points: 1253

  More actions

  August 6, 2011 at 7:01 am

  #1364770

  1. Which component to use ?

  Control Flow component called "Send Email Task" OR if we are too enamored with scripts stored procedure sp_send_dbmail is also an option.

  2. How to send attachments?

  The "Mail" tab in "Send Mail Task editor" allows for attachment

  3. How to create loop?

  You have the For, and For-Each loop containers. Decide what suits you

  4. What variables?

  You can always create user defined variables and use system variables if required in the expression but take care of the scope of the variables