Create Notification/Alert solution in 7 days
- Description
- Curriculum
- FAQ
- Reviews
A complete notification solution encompasses various components and functionalities to effectively deliver messages, alerts, updates, and reminders to customers across different platforms and devices.
This course is designed for beginners or experts who would like to learn step by step on how to create a notification system. In any industry, continuous communication to the customers is a key. It is important to keep your customer informed to ensure better customer satisfaction.
Business Use Case
-
School Management System – Send new students to the admission officer.
-
Doctors Office – Send new patients/ referral list.
-
Insurance Company – Send invoices/ quotation to new members.
-
Job Application – Send instant messages/email as the application changes status such as New Applicants, Short-listed, Called for Interview etc.
After completing this course, you will be able to:
-
Create a complete notification system
-
Support for delivering notifications through multiple channels such as text messages or emails
-
Communicate to customer in their native/preferred language to foster trust and credibility
-
Support for rich media content such as images, videos, GIFs and interactive elements
-
Work for any industry or for yourself as a side hustle.
Real-World Project
You will have the opportunity to create a Patient Post-Visit Follow-up tool for a KGM Medical Center.
Patient post-visit follow-up tool generates the customized email content based on the preferred language, processes and sends the email to patients.
-
1IntroductionVideo lesson
After completing this course, you will be able to create a simple notification solution to deliver messages, alerts, updates or reminders to users across different platforms and devices.
-
2Course OverviewVideo lesson
Real Word Project
Equipped with hands-on activities
Live Demo for you to follow along
Learn from scratch, step by step on how to create a simple package and automating to run the package on a planned schedule
If you are still struggling to follow along, don’t worry. I have shared all the codes for you to copy and paste
After completing this course, you can use this project in your resume to catch employer’s attention or you can start your own business as side gig.
-
3Course StructureVideo lesson
-
11Constructing email bodyVideo lesson
Email Body
Query data from the database
Use Recordset destination to save data in memory
Use Foreach Loop to write rows to email body
Foreach Loop Container
In SQL Server Integration Services (SSIS), the Foreach Loop Container is a control flow element used for looping through a collection of items such as files, folders, or database objects. It's particularly useful when you need to perform repetitive tasks on multiple items within a specified directory or collection.
Here's a general overview of how the Foreach Loop Container works:
1. Enumerator: You specify an enumerator type, which determines the collection of items to iterate over. Common enumerators include Foreach File Enumerator (for files in a directory), Foreach ADO Enumerator (for rows in a database table), and Foreach Item Enumerator (for a collection of specified items).
2. Collection: You define the collection that the enumerator should iterate over. For example, if you're using the Foreach File Enumerator, you specify the folder path and optionally a file mask to filter the files.
3. Variable Mapping: Within the Foreach Loop Container, you typically use variables to store information about each item as you iterate through the collection. You map these variables to the properties of the current item during each iteration.
4. Loop Body: Inside the container, you place the tasks or components that you want to execute for each item in the collection. These tasks will run once for each item in the collection.
5. Iteration: During each iteration of the loop, the Foreach Loop Container updates the variables with information about the current item, then executes the tasks within the loop body.
6. Completion: Once all items in the collection have been processed, the loop ends, and the control flow continues with the tasks or components following the Foreach Loop Container.
Here's a simple example scenario: Suppose you have a directory containing multiple CSV files, and you want to import each file into a SQL Server database. You could use a Foreach Loop Container to iterate over each file in the directory, with tasks inside the loop to import the data from each file into the database.
The Foreach Loop Container provides flexibility and automation for handling repetitive tasks within SSIS.
It allows you to dynamically process multiple items without the need to hard-code each item individually. This makes it a powerful tool for automating ETL (Extract, Transform, Load) processes and other data integration tasks within SSIS.
Recordset Destination
In SSIS, the Recordset Destination is a data flow destination component that allows you to store the result set of a query or the output of a data flow task into an object variable as an ADO.NET dataset or recordset. This object variable can then be used elsewhere in the SSIS package for further processing.
Here's how it generally works:
1. Configuring the Recordset Destination: You drag and drop the Recordset Destination onto the Data Flow canvas in SSIS. Then, you configure it by specifying the destination connection manager (typically an ADO.NET connection manager) and the object variable where you want to store the result set.
2. Mapping Columns: If you're storing the output of a data flow task, you map the columns from the data flow output to columns in the recordset destination. If you're storing the result set of a query, you typically won't need to map columns as they're already defined by the query.
3. Execution: When the data flow task containing the Recordset Destination executes, it retrieves the data from the source (such as a database table or another data flow task) and stores it in memory as a dataset or recordset object.
4. Usage of Object Variable: Once the data is stored in the object variable, you can use it in subsequent tasks or components within the SSIS package. For example, you might use it as a data source in another data flow task, or you might iterate through the rows using a Foreach Loop Container.
The Recordset Destination is particularly useful in scenarios where you need to manipulate or process the data within the SSIS package itself, rather than immediately loading it into a destination database. It provides flexibility in handling intermediate data within the package's workflow.
For example, you might use the Recordset Destination to store the result set of a complex query, perform additional data transformations or calculations on that data within the package, and then finally load the transformed data into a destination database.
Overall, the Recordset Destination is a valuable tool for managing and manipulating data within SSIS packages, enabling you to perform more advanced ETL processes and data integration tasks.
-
12Formatting Email BodyVideo lesson
In SQL Server Integration Services (SSIS), formatting the email body is typically done using a Script Task or an Expression within an SMTP Connection Manager. Here's a basic outline of how you can achieve this:
1. Using a Script Task:
- Add a Script Task to your SSIS package's Control Flow.
- Open the Script Task editor and choose the appropriate language (C# or VB.NET).
- Write code within the Script Task to construct the email body according to your desired format. You can use HTML formatting for styling.
- Assign the constructed email body to a variable.
- Pass this variable to an SMTP Connection Manager or another component responsible for sending the email.
2. Using Expressions in SMTP Connection Manager:
- If you're using an SMTP Connection Manager to send emails, you can use expressions to dynamically construct the email body.
- Create a variable that holds your email body content, formatted as desired (e.g., using HTML).
- Set the Expressions property of the SMTP Connection Manager to dynamically assign the email body variable to the appropriate property (such as MessageSource or MessageBody).
Here's a simplified example of how you might construct an email body with HTML formatting using a Script Task in C#:
------------------------------- C# --------------------------------------------------
string emailBody = "<html><body>";
emailBody += "<h2>This is a formatted email body</h2>";
emailBody += "<p>This is a paragraph of text.</p>";
emailBody += "</body></html>";
// Assign the email body to a variable to pass to the SMTP Connection Manager
Dts.Variables["User::EmailBody"].Value = emailBody;
---------------------------------------------------------------------------------------
Remember to properly configure your SMTP Connection Manager to use HTML formatting for the email body if you're sending HTML-formatted content.
Using these methods, you can format the email body in SSIS to meet your specific requirements, whether it involves simple text or more complex HTML formatting.

External Links May Contain Affiliate Links read more