Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag BCP (Bulk Copy Program) Rss

   Items 1 to 3 of 3   

Dynamic sql for convert SQL statement to txt/csv file

Github link: Quick export to flat file. Before use please enable xp_cmdshell.  Read more...
Rating: |  Discuss |   Briefcase | 1,729 reads

BCP results

By Stuart Davies 2014/07/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,914 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: | Category: bcp (bulk copy program)
Rating: |  Discuss |   Briefcase | 5,565 reads
   Items 1 to 3 of 3   
bcp format files (1)    
bulk insert (1)    
csv (1)    
etl (1)    
export data (1)    
importing text files (1)    
security (1)    
sql spackle (1)    
t-sql (1)