SSIS :Sending an Email from SSIS with a Field from a DB in the TO

  • I have the email address of all the managers in a table in a database.

    I want to enter this field as the TO or CC. is there a way this can be done?

  • Assuming you want to send 1 email to everyone at the same time, write a query that will return these with semicolons between them. Put this query into an Execute SQL Task. Have the Execute SQL Task populate a variable with a string data type by mapping the Result Set's one column to the variable name. In the next step in the flow have a Send Mail task with with an expression for the property of ToLine set to the value of your variable.

    Let me know if you need more detail on any of the above,


    Rick Todd

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply