SQL Loader : BCP Basics (Bulk Copy Basics)

Read this to understand what BCP is about and how SQL Loader works

1) BCP Basics
http://sqlfool.com/2008/12/bcp-basics/

2) SQL Loader from Oracle

http://www.indiana.edu/~dss/Services/DataWarehouse/Oracle/sqlload.html

3) Introduction to SQL Loader  : A tutorial from Kent University.

http://www.cs.kent.edu/~wfan/link/dbapre/dbatest/54910f.htm

4) SQL Loader Concepts from Oracle

Some good diagrammatic explanations given here about what the loader is about, it's capabilities and how it works.

http://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_concepts.htm#i1004619

5) BCP Utility

http://technet.microsoft.com/en-us/library/ms162802.aspx

6) Use a format file to import bulk data in SQL Server
 
http://technet.microsoft.com/en-us/library/ms178129.aspx