SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag BCP Rss

Refine your search with one of the following additional tags (with number of items):

Export (3)     BLOB Manipulation (1)     Disaster Recovery (1)     SQLCLR (1)    
SQL Server 2005 (3)     Bulk import (1)     ETL (1)     VBScript (1)    
Extract, Transform, Load (ETL) (2)     bulk insert (1)     Excel (1)     xp_cmdshell (1)    
XML (2)     bulkimport (1)     import (1)     xportxml (1)    
Backup (1)     Common Language Runtime (CLR) (1)     OpenDataSource (1)    
   Items 1 to 9 of 9   
 

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 | 911 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: (not yet rated) |  Discuss |  Briefcase | 806 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 | 2,634 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 2009/02/11 | Source: SQLServerCentral.com | Category: BCP
Rating: |  Discuss |  Briefcase | 1,880 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 2009/02/04 | Source: SQLServerCentral.com | Category: BCP
Rating: |  Discuss |  Briefcase | 7,554 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 | 7,157 reads

Bulk Copy All?Table Data into formatted files

Bulk copy table data into formatted files.  Read more...
By Mahidhar Vattem | Source: SQLServerCentral.com | Category: BCP
Rating: (not yet rated) |  Discuss |  Briefcase | 377 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 | 6,953 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 | 4,717 reads
   Items 1 to 9 of 9