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  

47 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. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. The company was commended for their responsiveness, Niche Edit expertise, and customer service.

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

    shaw internet plans

    ReplyDelete
  19. 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
  20. 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
  21. 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
  22. This comment has been removed by the author.

    ReplyDelete
  23. 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
  24. rulz APK Download for Android Mobile, Free Download MovieRulz App Telugu, Tamil, English, Kannada for your Android TV, Android.

    ReplyDelete
  25. Thank you so much for the post you do. I like your post and all you share with us is up to date and quite informative, i would like to bookmark the page so i can come here again to read you, as you have done a wonderful job. hootsuite alternatives

    ReplyDelete
  26. สล็อต xo เครดิตฟรี


    เกมส์สล็อตออนไลน์เหล่านี้เป็นเกมส์ที่ยอดนิยม และมีผู้เล่นมากที่สุดตั้งแต่ แอพ Slotxo ได้เปิดให้บริการมานั่นเอง จากตัวอย่างจะแสดงให้เห็นได้ว่าเกมส์สล็อตออนไลน์ จาก SLOTXO นั้นมีธีมของเกมส์ที่แตกต่างหลากหลายกันออกไป ไม่ว่าจะเป็นแนว

    ReplyDelete
  27. slot joker

    For a new website, there are many promotions to choose from. HUBJOKER888 is a website that has been launched with an automatic system, whether it is making transactions, applying for membership, depositing, withdrawing, making transactions.

    ReplyDelete
  28. Citycarpart

    We are a team of enthusiastic developers and entrepreneurs who decided to convert their common experience into this web store. We hope you’ll like it as much as we do and have a great shopping experience here. Our prime goal is to create a shop in which you can easily find whatever product you need.

    ReplyDelete
  29. ULTRACLUB ASIA บาคาร่าออนไลน์ มาตรฐานระดับสากล
    สมัคร ฝาก-ถอน อัตโนมัติทั้งระบบ พร้อมทีมแอดมินมืออาชีพ


    Sexy baccarat
    ไพ่แคง
    ไพ่แคง ออนไลน์
    เทคนิคบาคาร่า
    เว็บคาสิโนออนไลน์
    slotxo
    pgslot
    เว็บเดิมพัน
    บาคาร่า

    ReplyDelete
  30. เว็บไซต์ที่ให้บริการเกมส์เดิมพันคาสิโนออนไลน์ทุกรูปแบบ อาทิเช่น เดิมพัน บาคาร่าออนไลน์ ผ่านมือถือได้เงินจริง ไพ่เสือมังกร ไฮโล รูเล็ต แบล็คแจ็ค เดิมพันเกมส์ไพ่ต่างๆ ป๊อกเด้ง ไพ่แคง น้ำเต้าปูปลา ไพ่สามกอง เป่ายิงฉุบได้เงินจริง ปั่นแปะผ่านมือถือ สามารถเล่นร่วมกับสมาชิกท่านอื่นที่เดิมพันอยู่จริง

    เสือมังกร ออนไลน์
    เสือมังกร วิธีเล่น
    ไฮโลออนไลน์
    ไฮโล วิธีเล่น
    รูเล็ต วิธีเล่น
    เว็บคาสิโน
    แอพคาสิโน
    บาคาร่า

    ReplyDelete
  31. In this particular article, you will see a summary, satisfy browse this post. How do I scrape Google leads?

    ReplyDelete
  32. Your blog is too much amazing. I have found with ease what I was looking. Moreover, the content quality is awesome. Thanks for the nudge! direct mailing company

    ReplyDelete
  33. I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... Zendable

    ReplyDelete
  34. I am genuinely thankful to the holder of this web page who has shared this wonderful paragraph at at this place FUD crypter

    ReplyDelete
  35. Major Thanks for the blog post. Really thank you! Want more.post carousel to instagram from pc

    ReplyDelete
  36. Fantastic post however , I was wanting to know if you could write a litte more on this subject?
    I’d be very thankful if you could elaborate a little bit
    more agen joker123. Thank you!
    Excellent post. I used to be checking constantly this blog and I am
    impressed! Very useful information specifically the ultimate phase ?? I take
    care of such information bandar togel online much.
    Its awesome when i found this written in internet, i very appreciate this who ever give us the information about
    bandarq online much.

    ReplyDelete
  37. Amazing. What an amazing website. Please keep sharing more information on this informative topic. Turky visa USA citizen is a fast track electronic visa system that allows Americans to apply for visas.

    ReplyDelete
  38. I am thankful to this blog giving unique and helpful knowledge about this topic. herbal clinic Brisbane

    ReplyDelete
  39. If you could contact anyone in any company in the world, who would you start with? b2b email

    ReplyDelete
  40. https://www.floraindia.com/cake-delivery/delhi.html You can gift the various gifts on Christmas like festivals. Cakes, flowers, chocolates and much more. Here from this article you can know several offerings for this Christmas season to mesmerize and surprise your loved ones.

    ReplyDelete
  41. BBW sex doll for sale. Full-TPE and Full-silicone dolls both can be found here, Realistic touch, just like real teenage girl, affordable price. Free & discreet shipping without any legal risk.bbw sexdolls

    ReplyDelete
  42. The glass dildo is hard and strong. And you can heat or cool the glass wand. glass dildo

    ReplyDelete
  43. The huge girth of a thick dildo can provide you with stimulation that ordinary dildos cannot, increasing sexual pleasure and satisfaction while satisfying different preferences.
    https://www.lovetoyshub.com/

    ReplyDelete
  44. Discover the unconventional world of horse dildos and their role as alternative sex toys in fulfilling unique desires. Explore how these specialized toys offer customizable options for those seekin
    lovetoyshub

    ReplyDelete