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.

T-SQL writing to a file txt or csv

I've spent all day scouring the net on answers. Apparently tsql doesn't have its own nifty write to file commands. …

sql-server tsql file-io ole bcp
BCP Import Help

I'm having trouble importing data from a tab-delimited *.txt file into my SQL table using BCP. I keep getting two "…

sql bcp
BCP returns no errors, but also doesn't copy any rows

I'm trying to dump a very large set of data from a .csv file into a SQL Server 2012 database. Rather …

sql sql-server bcp
Where we are giving password by using BCP command?

I am pretty much new to bcp but I researched quite a bit and can not find any resource that …

sql sql-server sql-server-2008 sql-server-2005 bcp
BCP - Invalid character value for cast specification when importing to table with IDENTITY column

I am trying to load a file from UNIX to SQL Server. When I run the BCP getting the error …

sql-server sql-server-2008 bcp
Export xml data using BCP Command in SQL Server

I am trying to export datable data in xml format but,Problem is like i can able to create xml …

sql-server sql-server-2008 bcp
Can BCP copy data directly from table to table?

I've got a situation where I need to copy several tables from one SQL Server DB to a separate SQL …

sql-server-2008 bcp
Run a shell command with arguments from powershell script

I need to extract and save a some tables from a remote SQL database using bcp. I would like to …

powershell bcp
how do i pass in a command to sqsh and get the output to a file in one go?

I'm trying to set up a simple loop to periodically query a database table in bash. Normally I seem to …

sql-server database bcp sqsh
Sybase bcp error

What i want to do is copy a table into a file, truncate the table and copy the data back …

database sybase sap-ase bcp bulk-load