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.

Sql Bulk insert XML format file with double quotes in terminator

I'm trying to insert some data into a table from a csv document which has all of the fields delimited …

sql-server xml bulkinsert bcp
bcp won't output temp tables

I have a stored procedure that stores values in temp tables. It all works well, but I can not bcp …

sql bcp
BCP utility:"Copy direction must be either 'in', 'out' or 'format'"

I get below mentioned error when I run BCP command for trusted connection: Copy direction must be either 'in', 'out' …

sql-server sql-server-2005 bcp
How to get the date format in windows batch file as 'yyyymmdd'?

I am writing a Windows Batch file and the batch file is supposed to output a file in a specific …

sql-server windows date batch-file bcp
What will be BCP format for inserting a identity column

I am facing problem while I am trying to insert data to a table using BCP. The table has a …

bcp
Why does bcp output null when the column contains an empty string and empty string when the column is null?

This struck me as really weird behaviour and I spent a while checking for bugs in my code before I …

sql sql-server null bcp
How to write using BCP to a remote SQL Server?

I have a remote SQL Server with a hostname I am using to connect to. BCP suggests to use bcp …

sql-server command-line-interface bcp bulk-load
Why do I get "XML parsing: line 2, character 0, incorrect document syntax" when Bulk Inserting in MS SQL Server

I'm doing a BULK INSERT into a table using a FMT format file, but I get the following error: XML …

sql-server bulkinsert bcp
SQL Server Bulk Import with format file - An unexpected end of file was encountered in the data file

I am testing bulk import from a comma separated csv file to sql server 2012. for this purpose i have created …

csv sql-server-2012 bcp bulk-import