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  

31 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
  10. What does it cost to live in the Bay area? When it comes to the most desirable cities in the United States? The first city that comes to our head is the Bay Area, the panorama is breath-taking and beautiful, the weather is astonishing and the diversity is phenomenal.

    ReplyDelete
  11. 7 Coolest Offices in California

    When you first heard the word office? What is the first thing that comes into your mind?

    You must be wondering that offices only mean white walls, dark doors, and white cubicles.

    These were the days of the Grey that now has been gone.

    Nowadays, many companies invest their money in the interior of the offices because it’s truly said, “You should love the space where you work”.

    ReplyDelete
  12. 5 effective ways in which you can promote your business

    Every other business owner wants to showcase that their business is the best and they can deliver the best products and services and all they want is to put their services in front of the potential customers. However, there are many traditional ways in which one can promote business but all these traditional ways of promoting can indeed be strenuous and costly......

    ReplyDelete
  13. Latest News Dental Success Blo

    Townie News Wire. Events. Upcoming Events Townie Webinars. More. Free e-Books Townie Poll Townie Perks Student Membership · Download .Most Active Blogs. Skip Navigation ... Dentaltown Learning Online. By Howard ... 11/6/2018 · Dental Success Blog ... The Best Practices Show with Kirk Behrendt.

    ReplyDelete
  14. Key benefits of hiring a moving company in California

    The process of moving is indeed strenuous and moving across city lines is much more chaotic. Therefore, moving across California and other ...

    ReplyDelete
  15. i never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. google email extractor free download

    ReplyDelete
  16. What a thrilling post, you have pointed out some excellent points, I as well believe this is a superb website. I have planned to visit it again and again. bulk email platform

    ReplyDelete
  17. When your letter is readied, ensure it is altered appropriately prior to sending it to your contacts. Contingent upon the idea of your business, you should target individuals who might be keen on your offer. how to get off email lists

    ReplyDelete
  18. It's much similar to the TV or radio were the point at which they started and the force it bridles for the individuals who use it will radiate through. SMM Panel

    ReplyDelete
  19. Superior post, keep up with this exceptional work. It's nice to know that this topic is being also covered on this web site so cheers for taking the time to discuss this! Thanks again and again! one funnel away challenge

    ReplyDelete
  20. superslop

    Superslot หรือ ภาษาไทย บ้านๆ เรียกว่า ซุปเปอร์สล็อต เราคือผู้ให้บริการสล็อตออนไลน์มีตัวเกมสล็อตให้เลือกเล่นจำนวนมากบนมือถืออันดับ 1 ทั้งฟรี

    ReplyDelete
  21. dog health
    Are you a cat or dog owner looking to maximize nourishment for your furry family members? As a pet parent, you naturally strive to provide your pets with the best lifestyle options available.

    ReplyDelete
  22. For the excellent company Begin with the internet site, the customer service over the cell phone, to the detailed care they deliver in your presence
    leather jacket

    ReplyDelete
  23. The company was commended for their responsiveness, Niche Edit expertise, and customer service.

    ReplyDelete
  24. Thank you for oder my Gigs. Please share the details guide in the project

    shaw internet plans

    ReplyDelete
  25. indian visa Thisare a private website offering our users online application services which include assistance with their application for Electronic Travel Authorization for travel to India. 

    ReplyDelete
  26. Now I understand why people are recommending me this brand naming agency! With their simple method that leads to fantastic name ideas for my brand. Would definitely recommend this as well. Email Harvester

    ReplyDelete
  27. Its such as you read my mind! You appear to understand
    a lot about this, such as you wrote the e book in it or something.
    I think that you could do with some % to drive the message home a little bit,
    however other than that, that is great blog. An excellent read.
    I will definitely be back.
    https://www.coydoll.com/

    ReplyDelete
  28. This is my first time visit to your blog and I am very interested in the articles that you serve. Provide enough knowledge for me. Thank you for sharing useful and don't forget, keep sharing useful info: ClickFunnels Vs Kartra

    ReplyDelete
  29. This comment has been removed by the author.

    ReplyDelete
  30. E-mail has become one of the most important applications for computer users. It is quickly replacing the Post Office snail mail. With e-mail we can send variety of messages including video e-mail, pictures, links to Internet information, and more. Most e-mail users tend to save all e-mail. That can become a problem because e-mail systems have limits. Further, when Microsoft Outlook e-mail or a computer's hard disk crashes all e-mail can be lost. In this article we examine in simple terms how e-mail works, Outlook's limits, aol mail login, and more to help you work more effectively with your e-mail.

    ReplyDelete