- [Instructor] In this course we will load and parse text data from various source files into tables. The data will be manipulated and cleaned, and formed into orders to be processed. For each order file we will load the data into staging tables. Then we will validate the data and update production data. We will then create customer transactions when needed. After each file has been loaded we will send an email notifying users of the uploaded data. If there have been any exceptions or data validation errors, emails detailing those issues will be sent. Finally, the original file is archived. They key functional points of this tutorial are that this process is implemented using just SQL. It is designed to run as a scheduled job that requires no human intervention. That being the case, we will implement a robust and error tolerant design pattern. There will be data validation and error handling. Users will be notified of the process completion and exceptions by email. To implement this functionality we will make use of dynamic SQL to create reusable and flexible code, SQL Server's Bulk insert statement, SQL cursors to perform complex procedural processing, SQL scalar and table functions to group functionality and make our code clean and concise, table variables to pass complex data between functions, and setting up and using SQL Server's DB Mail.