SSIS Tutorial Part 87-Read Email Info from SQL Server Table & Send Email by using Send Mail Task
Автор: TechBrothersIT
Загружено: 2015-07-05
Просмотров: 19447
SSIS Video Scenario:
Let's say we have a table which store Email To , Email From , Subject and Body of emails those we need to send on daily basis. We want to design an SSIS Package that runs on schedule and send email for each of the record that is stored in the Table.
Solution:
To solve above scenario, we will be using following components of an SSIS Package
1.Read all the records from a table and stored in Object type variable by using Execute SQL Task
2.Loop through Object type variable by using For-each Loop Container and store values in variables
3.Write Expressions in Send Mail Task
To follow Step by Step SQL Server Integration Services(SSIS) Video Tutorial By TechBrothers, please open below link.
http://www.techbrothersit.com/2014/12...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
