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.
- Problems with SQL Server Import/Export
- Using a C# utility to import data
- Useful stored procedures and functions for importing data
Real-World Techniques Explained Simply
Nashville, Tennessee, United States