Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag BCP (Bulk Copy Program) Rss

   Items 1 to 2 of 2   
 

BCP results

By Stuart Davies 2014/07/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,816 reads

Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

BULK INSERT and BCP are powerful, high performance tools for importing text files. SQL Server MVP Jeff Moden gives us several nifty tips in this introduction to BULK INSERT and BCP Format Files including "Skipping Columns" and the sequestration of bad rows while still loading all the good data.  Read more...
By Jeff Moden 2014/01/23 | Source: SQLServerCentral.com | Category: bcp (bulk copy program)
Rating: |  Discuss |   Briefcase | 5,008 reads
   Items 1 to 2 of 2   
 
Tags
bcp format files (1)    
bulk insert (1)    
etl (1)    
importing text files (1)    
security (1)    
sql spackle (1)    
t-sql (1)