Session

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

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top