Tips and Tricks for Importing Data into SQL Server

The SQL Server Import/Export Wizard tool is not a good tool for importing .CSV files. SSIS can sometimes be overkill. In this seminar a free CSV import tool written in C# is illustrated. In addition, you learn a process for importing .CSV data, then massaging that data into a final form from which you perform better reporting on that data. You see some useful stored procedures and functions that can be used to clean up and import data.

Learning Objectives
- Problems with SQL Server Import/Export
- Using a C# utility to import data
- Useful stored procedures and functions for importing data

Paul Sheriff

Real-World Techniques Explained Simply

Nashville, Tennessee, United States

View Speaker Profile