Send Load Summary Email by using Send Mail Task in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

Scenario:

Let's say we have to create an SSIS Package for Insert/Update Operation. We have to read the data from Flat File and then Insert or Update in SQL Server Table depending upon the value of ID column. Once the UPSERT operation is done, we want to send the Number of Records Inserts or Number of Records Update.


Solution

To solve this scenario we can use following parts of an SSIS Package

  1. Create SSIS Package Parameters to store Email To and Email From
  2. Use Data Flow Task to read the records from Flat file and Insert the New Records and Update the existing Records. 
  3. Use Lookup Transformation in Data Flow Task to Find out if Record already exists of not
  4. Create Variables InsertCount and UpdateCount to store Insert and Update Record Count
  5. Use Variables in Expressions in Send Mail Task to Build Load Summary Email



Expressions
"Hi Team,
Package has completed successfully, please check the load summary below
Total Records Inserted : "+(DT_WSTR,10) @[User::InsertCount]+"
Total Records Updated : "+(DT_WSTR,10)  @[User::UpdateCount]+"

Please contact Tech Brothers in case of Questions.
Thank you
Tech Brother"






How to Send Load Summary Email by using Send Mail Task in SSIS Package - SSIS Tutorial



  Related Posts/Videos on Send Mail Task  

9 comments:

  1. A very awesome blog post. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. email bulk marketing list

    ReplyDelete
  2. Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!Thanks cfa level 1 summary

    ReplyDelete
  3. Yahoo mail is an web based email service. Yahoo mail service can be accessed through different devices including computer, tablets, smart phones, and more. Users with a valid Yahoo account can sign into Yahoo com to access the features of Yahoo mail. A smile web browser can be used to sign into Yahoo.com. Users can also download Yahoo app to their mobile phone and login to their account. yahoo mail sign in

    ReplyDelete
  4. buy smart carts online. organic smart cart. are the high potency distillate free from any solvents. If this product was accurate with its claim.

    ReplyDelete
  5. Stonersdankshop established in 2016 in United States has been the best vape shop exporting vape products online to most vape shops in USA and to vape .. buy exotic carts online

    ReplyDelete
  6. Enrich your experience of online shopping by navigating our Skin Care products including Hair removal products, Facial cleansing brush, Epilators and much ...

    IPL HAIR REMOVER,
    FACIAL BRURSH,
    HAIR TRIMMER,
    MICRODEBRASION,
    BLACKHEAD REMOVER,
    WATERPROOF PORTABLE,

    ReplyDelete
  7. Royal photo Booths Australia At Royal Booths,we want to make a good impression with you, hence we go above & beyond when it comes to forming that initial relationship with our customers.

    ReplyDelete
  8. At V P Associates Chartered Certified Accountants and Tax Advisor Accountant services, East Grinstead, West Sussex, we more than just respond to your need. Tax Advice

    ReplyDelete
  9. Our store offers many styles of advanced tpe sex dolls, soft skin made of tpe material, realistic tpe sex dolls to achieve your desire for sex.Buy real realistic tpe ... realistic sex doll

    ReplyDelete