Top "Bcp" questions

The bulk copy program `bcp` is a command line tool that can be used to export data from Microsoft® SQL Server™ or SAP Sybase Adaptive Server Enterprise databases to a data file in a user-specified format.

I/O error while reading BCP format file

Today I created a new staging table and a BCP .fmt file. I created some test data and attempted to …

sql-server-2008-r2 bcp
exec xp_cmdshell bcp syntax

I can't seem to find the right syntax to export data with column names using exec xp_cmdshell bcp in …

sql-server bcp xp-cmdshell
Best way to export/import MS Sql 2008 Geography data

(ANSWER) How to export some Geography data from a Microsoft Sql Server 2008. You'll need to use the command line argument …

sql-server-2008 export geography bcp
How to transfer data from a SQL Server Database to a Oracle Database

The current application I'm working lets call X is an archiving application for the data kept another application say Y. …

sql-server sql-server-2005 oracle unix bcp
Getting bcp.exe to escape terminators

I need to export some data using SQL Server 2000's BCP utility. Sometimes my data contains characters, such as \t …

sql-server-2000 export escaping bcp
Can SQL Server bcp in a file with Unix line endings?

I'm trying to use the SQL Server bcp utility to import a text file from a samba share. bcp is …

sql-server database cross-platform bcp line-endings
SQL 2012 bcp call returns SQLState = 28000. NativeError = 18456 Login failed for user

I’m working with a SQL stored procedure that makes a call to xp_cmdshell. xp_cmdshell has been enabled, …

sql-server sql-server-2012 bcp xp-cmdshell
character encoding issue with the BCP and ó

I have a file that needs to go to Poland. In my data I have an ó. When I output the …

sql-server unicode character-encoding bcp
Decrease the output of bcp export

In our project we are using bcp command to export about million of rows and logging the output to an …

sql-server-2008 export-to-csv bcp
Rollback for bulk copy

I have an application that make a copy from my database by bulk copy class in c#. Can I rollback …

c# sql-server rollback bcp sqlbulkcopy