Paul Sheriff

Nashville, Tennessee, United States

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

Paul has over thirty three years of experience architecting information systems and his expertise is in much demand from Fortune 500 companies. Paul is a top-notch instructor, a pluralsight author, has published 300+ articles, and authored over 14 books on topics ranging from C#, SQL Server and many .NET technologies. Paul has over 24 courses in the library on topics ranging from JavaScript, Angular, MVC, WPF, XML, jQuery and Bootstrap. Paul speaks at many different conferences and user groups around the world.

Paul's full speaker profile