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

Content with tag BCP Rss

   Items 1 to 16 of 16   
 

Solving a Problem Importing Integers Using Format Files

When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.  Read more...
By Banyardi Schmardi 2012/02/16 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 3,824 reads

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.  Read more...
By Bret Lowery 2011/07/18 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 7,709 reads

Export Data in Text File Using BCP

This example shows how to export data in txt file using bcp command From SQL Server 2005  Read more...
By Manish Mathur 2011/04/20 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 4,506 reads

My favorite way to access Excel files

Using opendatasource to retrieve data from Excel files as if querying a table.  Read more...
By Gaby Abed 2011/03/22 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 11,371 reads

Dynamically generate Format File For OPENROWSET tekst file import

Dynamically generate XML format file for use with OPENROWSET or XML bulk insert.  Read more...
By Joey Moelands 2010/11/19 | Source: SQLServerCentral.com | Category: openrowset
Rating: |  Discuss |   Briefcase | 1,383 reads

Easy Error Trapping When Using xp_cmdshell

Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.  Read more...
By Sylvia Moestl Vasilik 2010/02/02 | Source: SQLServerCentral.com | Category: error handling
Rating: |  Discuss |   Briefcase | 7,207 reads

Bulk Loading Data

By Steve Jimmo 2009/12/23 | Category: bcp
Rating: (not yet rated) |  Discuss |   Briefcase | 2,738 reads

SQL Server 2005 - Work with Flat Files

It's a scripts about working with Flat Files  Read more...
By Luan Moreno M. Maciel 2009/11/03 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 1,895 reads

Export/import relational data across SQL Servers

The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server keeping the relational integrity intact, even when new primary keys are generated.  Read more...
By Ashish Kumar-1095774 2009/07/03 | Source: SQLServerCentral.com | Category: export
Rating: |  Discuss |   Briefcase | 1,430 reads

Importing and exporting bulk data with the bcp utility

The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.   Read more...
By Additional Articles 2009/03/04 | Source: SearchSQLServer | Category: bulk import
Rating:  Rate this |   Briefcase | 3,164 reads

Export Data in Text File Using BCP

This example shows how to export data in txt file using bcp command From SQL Server 2005  Read more...
By Manish Mathur 2011/04/20 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 4,506 reads

My favorite way to access Excel files

Using opendatasource to retrieve data from Excel files as if querying a table.  Read more...
By Gaby Abed 2011/03/22 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 11,371 reads

Simple way to export SQL Server data to Text Files

With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.  Read more...
By Additional Articles 2008/12/05 | Source: MSSQLTips.com | Category: export
Rating:  Rate this |   Briefcase | 8,810 reads

Bulk Copy All?Table Data into formatted files

Bulk copy table data into formatted files.  Read more...
By Mahidhar Vattem 2008/10/22 | Source: SQLServerCentral.com | Category: bcp
Rating: (not yet rated) |  Discuss |   Briefcase | 1,102 reads

Binary Files Import and Export

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.  Read more...
By Sergey Benner 2008/08/28 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 8,847 reads

Exporting and Versioning Lookup Data: A Real-World Use of the CLR

The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.  Read more...
By Solomon Rutzky 2008/06/24 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 5,106 reads
   Items 1 to 16 of 16   
 
Tags
export (4)    
sql server 2005 (4)    
bulk insert (2)    
etl (2)    
extract, transform, load (etl) (2)    
import (2)    
sqlclr (2)    
xml (2)    
xp_cmdshell (2)    
backup / restore (1)    
blob manipulation (1)    
bulk import (1)    
bulkcopy (1)    
bulkimport (1)    
c# (1)    
common language runtime (clr) (1)    
csv (1)    
disaster recovery (dr) (1)    
error handling (1)    
excel (1)    
format file (1)    
import files (1)    
json (1)    
opendatasource (1)    
openrowset (1)    
vbscript (1)    
xportxml (1)