Importing CSV files Without Surprises covers quoted delimiters, UTF-8 encoding, dates, staging tables, and SQL Server BULK INSERT FORMAT = ‘CSV’.
SQL SERVER – Import CSV File into Database Table Using SSIS
How to import CSV file into database table using SSIS, step by step with images, so you can automate the load instead of running Bulk Insert by hand.
Turning a Comma-Separated Column Into a Proper Child Table
A list stuffed in one column makes every search a guess. Split it, clean it and move it into a child table, then check the result before you drop anything.
Fast Exports With bcp
Fast exports with bcp compares native and character files, shows a format file, and explains where batch size helps and how to check a large export.
Loading Large Files Fast With BULK INSERT
BULK INSERT loads large SQL Server files through a tested format, accessible path, staging table, measured batches, and final validation.
Minimal Logging for Bulk Loads
Minimal logging for Bulk Loads depends on recovery model, table shape, and locking; learn the prerequisites, tradeoffs, and how to verify a load.
SQL SERVER – Comma Separated Values (CSV) from Table Column
The script I use most often to build Comma Separated Values (CSV) from a table column with FOR XML PATH. I think XML is the best option for code and speed.