Scenario:
We have created an SSIS Package, that fails sometime. The only way to find out if the Package is failed to check SQL Server Job history or alerts generated by SQL Server Agent Job. We want to include components in SSIS Package so we can send an Email from SSIS Package with Error Information when the Package fail.Solution:
In this video we will find out the solution for above scenario, we will learn below items in this Video
How to create SSIS Package Parameters
How to use Event Handlers in SSIS Package for OnError Events
How to Create error in SSIS Package for Test Purpose
How to use Send Mail Task in Event Handler to send email with Error Code, Error Description etc.
Expressions used in the Send Mail Task MessageSource
" Hi Team
The Package "+ @[System::PackageName] + " has failed in "+ @[$Package::Environment]+" with below error
Error Code: "+ (DT_WSTR,50)@[System::ErrorCode]+"
Error Description: "+ @[System::ErrorDescription] +"
Error Source: "+ @[System::SourceName]+"
Please contact SSIS Team if have any questions
Thank you
Tech Brothers"
How to Send Error Email from an SSIS Package - SSIS Tutorial
Related Posts/Videos on Send Mail Task
- Create Load Summary Email logic in SSIS Package
- How to Configure Send Mail Task and Send Email in SSIS Package
- Create a file with Date From SQL Server Table and Send as Attachment in SSIS Package
- Attach Multiple Files Dynamically in Send Mail Task in SSIS Package
- Send List of Files from A Folder as Email by using Send Mail Task
- Use Send Mail Task with Precedence Constraints in SSIS Package
- Read Subject,Recipient and Body from SQL Server Table and Send Email by Using Send Mail Task
- Read EmailTo,EmailFrom,Subject and Body From Text File and Send Emails by using Send Mail Task in SSIS Package
- Send Load Summary Email by using Send Mail Task in SSIS Package
Their staff is personable both on the phone and in-person. Everyone has a positive, can-do attitude
ReplyDeleteTheir congenial, thoughtful approach to customer service informs both a Best Podcast Microphone for iPhones and their top-notch deliverables.
ReplyDeleteDiscover the pinnacle of email design with Stripo! Elevate your brand's digital presence with our exclusive collection of outlook email template design. Engage your audience like never before with sleek layouts and customizable elements that ensure your message stands out. Whether you're promoting products or sharing updates, our templates are crafted to maximize impact and deliver results. Join the ranks of savvy marketers who rely on Stripo for innovative solutions. Explore our outlook email template design today and transform your campaigns into captivating experiences. Start creating emails that leave a lasting impression!
ReplyDelete