Import and Validate CSV File Data Into SQL Server
In this lesson, we cover importing and validating text file data, data conversion, error logging and notification, and financial transaction creation. You’ll see how to create an SQL Server script that is robust, error-tolerant, and can be run as a scheduled unattended job. On top of demonstrating how to get text data into database tables using only SQL, this lesson highlights what kind of issues may be faced when integrating with third-party systems that have less-than-ideal data structures.
Learning Objectives
- Learn how to use SQL to import CSV file data
- Learn how to build robust and error-tolerant SQL code
- Learn how to send reports and error notifications
Intended Audience
- DBAs
- System analysts
- Programmers
- Anyone wanting to learn how to use SQL to solve common data import and transformation scenarios
Prerequisites
This lesson assumes students have basic SQL skills. Students should be familiar with:
- SLEECT, INSERT, UPDATE, and DELETE statements
- SELECT INTO temporary tables
- WHERE NOT EXIST clauses
- Stored procedures
- Variables
Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.