Saturday, January 19, 2008

Importing Text-based data into SQL Server using TSQL

Importing Text-based data into SQL Server using TSQL
Importing Text-based data: Workbench (simple-talk.com)
How to import text files into SQL Server, without resorting to DTS or SSIS scripting. They go on to show how much can be done in TSQL.

Fast Import with the Quirky Update technique
CSV Importing- Comma-delimited and Comedy-Limited.
Unrotating a CSV Pivot-table on import

Download:
TheCode

No comments: