Bulk Copy Program – BCP SQL

 

Bulk Copy Program (BCP) – command-line tool used to import or export data against a Microsoft SQL Server or Sybase database. The tool is often more efficient than more recent GUI-based applications, such as DTS, to import and extract data.

Resources:
http://en.wikipedia.org/wiki/Bulk_Copy_Program
http://databases.about.com/od/sqlserver/a/bcp.htm
http://sqlfool.com/2008/12/bcp-basics/

01 - Getting Started
02 - Performing Basic Tasks
03 - Basic Transformations
04 - Variables
05 - Data Types and Data Conversion
06 - Expressions
07 - Conditional split and derived column transforms
08 - Debugging
09 - Lookup Transforms
10 - Sequence Containers and FOR Loops
11 - Looping Over Files
12 - Other Foreach Loops
13 - Script Tasks using C#
14 - Script Tasks using Visual Basic
15 - Script Components
16 - Expression and Other Constraints
17 - Event-handling and logging
18 - Error handling
19 - Parameters and deployment
 
SharePoint Tutorial