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 www.pluralsight.com 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.