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


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.


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

"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  


  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

  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

  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 Users can also download Yahoo app to their mobile phone and login to their account. yahoo mail sign in

  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.

  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

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


  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.

  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

  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

  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.

  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”.

  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......

  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.

  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 ...

  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

  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

  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

  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

  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

  20. superslop

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

  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.

  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

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

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

    shaw internet plans

  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. 

  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

  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.

  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

  29. This comment has been removed by the author.

  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.

  31. rulz APK Download for Android Mobile, Free Download MovieRulz App Telugu, Tamil, English, Kannada for your Android TV, Android.

  32. 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

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

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

  34. 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.

  35. สำหรับท่านที่ต้องการเล่น pgslot ไม่ว่าจะเล่นผ่าน บราวเซอร์ Chrome , Firefox , Safari อื่นๆ เป็นต้น สามารถ ติดตั้งโปรแกรมบรคอมพิวเตอร์บนระบบปฏิบัติการ IOS หรือ Windows และสามารถเล่นได้สะดวกทุกที่บนมือถือที่เป็นสมาร์ทโฟน บน Iphone , Ipad และ Android .

    pg slot auto
    ทางเข้า pg slot
    pg slot โปรโมชั่น
    pg slot ทดลองเล่นฟรี
    pg slot ฝากถอนไม่มีขั้นต่ํา
    pg slot game
    pg slot demo
    pgslot เครดิตฟรี
    ดาวโหลด pgslot
    pgslot auto
    pgslot 77
    queenslot pgslot
    pgslot download
    slotkub pgslot
    pgslot 100
    slotxd pgslot
    superslot pgslot
    pgslot 311
    สล็อต pgslot
    pgslot สมัคร
    โปร pgslot

  36. We offer all the major sports such as English Premier League, Spanish La Liga, Italian Serie A, UEFA Champions League, French Ligue 1, German Bundesliga 1.


  37. หนังโป๊ฝรั่ง หนังโป๊ไทย xvideos หนังโป๊เกย์ ดูหนัง 18+ หนังอีโรติก คลิปโป๊นักศึกษา หนัง​โป๊ญี่ปุ่น เย็ดหี แตกใน xnxx Japanese Erotica.

    free porn

  38. 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.

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

    Sexy baccarat
    ไพ่แคง ออนไลน์

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

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

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

  42. 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

  43. 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

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

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

  46. Du Times- Du Times- Delhi University News


    Hello Dilli delhi update , Delhi news , Delhi Event , know about delhi


    Cost Of Cancer Treatment In India


    best laparoscopic surgeon in delhi best bariatric surgeon in delhi



    university news today University news



    best bariatric surgeon in Singapore best bariatric surgeon in Singapore


    best bariatric surgeon in Dubai best bariatric surgeon in Dubai


    indian news today Letest News , Political news , Today News Update


    islamic prayer times in my location Islamic Prayer Times


    Delhi University News Du Times- Delhi University News

  47. 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.

  48. You made blog such an interesting piece to read, dont forget share and read another blog situs slot pragmatic , link login joker123 , slot joker123 , situs togel online, situs pkv games

  49. You wrote this post very services for small businesses in boston UK The amount of information is stunning and also a gainful article for us. Keep sharing this kind of articles, Thank you.

  50. Before long, the clients of this help were furnished with the office of talking as well. junk mail senders

  51. 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.

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

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

  54. 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.

  55. 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