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.
SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column
I received following question in email : How to create a comma delimited list using SELECT clause from table column?