SSIS Tutorial 81-Create Load Summary Email logic in SSIS Package ( Send Mail Task)

Показать описание

In this video for SQL Server Integration Services Tutorial, you will learn how to build Load Summary email for your SSIS Package.
The load summary in SSIS Package email will be information for records extract, records loaded, records rejected, records update, record delete or record suspended.

Also this video is Answer for SQL Server Integration Services (SSIS ) Interview Question "
How would you create Load Summary Email logic in SSIS Package?
"

To follow Step by Step SQL Server Integration Services(SSIS) Video Tutorial By TechBrothers, please open below link.

Рекомендации по теме

Комментарии

I enjoyed watching this video and recommend others.

This is an important video for developers who maintain data in production.

Thanks for educating the community.

Thanks a bunch

krismaly

Wow, this is very helpful, thank you

romeror

Dear Amir, I enjoyed watching this video and recommend others to watch. Thanks for educating the community and appreciate your efforts in publishing this series of videos.

I think this is very imp Q and A.

Below question is not connected to this video.
Do you have any standards that you follow or generated by you for naming conventions like Pkg, Var, and so on.
If you have please could you share?

Thanks a lot

krismaly

Hi when I run my SSIS package the CPU utilisation is becoming 100% and machine is becoming slower .. Machine has 16GB ram .. I am running Master package with runs around 150 child packages .. any suggestions will be grateful to me

naresh

Hi, I have setup SQL server mail configuration & using that SMTP name as SMTP server name in SSIS 'Send mail task'. This is correct ?

While executing the SSIS. I AM GETTING BELOW ERROR.

Error: 0xC002F304 at Send Mail Task 1, Send Mail Task: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: The remote name could not be resolved: 'MailNotification'".

Task failed: Send Mail Task 1

Thanks in advance.

akjay

We cannot practice what you are doing without you sharing resource scripts. Very frustrating

danieljoubert

SSIS Tutorial 81-Create Load Summary Email logic in SSIS Package ( Send Mail Task)

SSIS Tutorial 81-Create Load Summary Email logic in SSIS Package ( Send Mail Task)

SSIS Tutorial Part 89-Send Load Summary Email by using Send Mail Task in SSIS Package

Summary videos on SSIS and what I have covered in this course!

What are the important components of the SSIS ?

How to Load all text or csv files to single Text or CSV File from a folder in SSIS Package-P177

SSIS Tutorial Part 83-Create file with Date From SQL Server Table & Send as Attachment SSIS Pack...

MSBI - SSIS - Overview of Available Transformations - Part-81

SQL Server Integration Services - How to Find and Replace object in SSIS Package

SSIS Tutorial Part 97-Create A Directory(Folder) For Each Day and Load Files on FTP Server

6. Developing a Query Driven Email Delivery System using SSIS

SSIS Tutorial Part 94- Filter Files by using WildCard in FTP Task in SSIS Package - SSIS Tutorial

10.2 SSIS Auditing

SQL Server Integration Services Interview - Search Object Name in SSIS Package File

SSIS Tutorial Part 106-Create Directory with Date on Local Path & download Files from FTP Server

SSIS Tutorial Part 80- Import Column Transformation in SSIS Package

SQL Server Incremental Statistics

SSIS Tutorial Part 145 - Data Viewer in Data Flow Task in SSIS Package

MSBI - SSIS - Using Windows Event Log And Text File Log Providers- Part-31

Databases: SSIS Row Count: Getting a null variable error where there is clearly a selected variable

2020 @SQLSatLA presents: Intelligent Query Processing by Andy Yun | @SentryOne Room

SSRS 4 Multi parameterized report

SSIS Conditional Split Audit Transformation

SSIS Tutorial Part 100-Delete Folder with Files from FTP Server by using Script Task in SSIS Package

MSBI - SSIS - Email Excel File Report - Part-129