encryting output file from BCP
I am exporting data using BCP util, in SQL native format, creating an output format. The proces executes a stored procedure, creating a temporary table, and then the BCP exports the table to an output file, in native SQL. Is there a method to have this output file encrypted without a 3rd party process?

Answer Question   |  December 7, 2012  4:17 PM
BCP Utility, encrypt files

Microsoft SQL Server BCP Utility password
I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the ‘in’ argument, a format file and an error file.  I have ‘hard coded’ the user name and password in the command line using the ‘U’ and ‘P’ arguments. I am looking for a [...]

Answer Question   |  November 23, 2010  7:42 PM
BCP Utility, BCP Utility password, SQL Jobs, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server Enterprise Edition

bcp – clock time meaning
Attempting to BCP a large resultset using a view and the queryout option. I have been playing with the network packet size and the size of the batche using join conditions. When looking at the command line output file. What do the values in “Clock Time (ms.) Total” signify. I am trying to measure the [...]

Answer Question   |  January 6, 2010  3:55 PM
BCP Utility, SQL 2005, SQL Server 2005

Changing BCP format file collation
Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. [...]

Answer Question   |  May 22, 2009  5:28 AM
BCP Utility, Collation, Format file, import/export

DTS import/export
Hi, I was wondering if the DTS import/export also recreate the table, the reason I am asking this I want to recreate a database using the Generate SQL Script but change the collation of the columns of the table, then import the data from that database to this new database. If it does recreate the [...]

Answer Question   |  May 21, 2009  3:18 AM
BCP Utility, DTS Import/Export Wizard

How to write Bcp command to insert data in to a table
Hi, I have a file which contains the data 2:23:3#1:2:4#2:3:5 i have to insert the data in to the table in multiple rows from a single file as #–indicates to be inserted in next row : –indicates next column column1 column2 column3 2 23 3 1 2 4 2 3 5 I need to use [...]

Answer Question   |  January 8, 2009  2:34 PM
BCP Utility, SQL, SQL 2005

BCP and SQL2005 collation issues
I get this error: Error = [Microsoft][SQL Native Client]Unable to resolve column level collations SQLState = 01000, NativeError = 5701 I am using the standar collation that comes with SQL2005

Answer Question   |  September 3, 2008  3:54 AM
BCP Utility, Bulk Copy Program, SQL Server 2005

BCP Utility With Additional “INSERT VALUES” Clause
I’ve nested 23 separate BCP commands into a single BAT file. Each BCP command pulls data from a separate text file and inserts the data into a single table. Here’s the kicker, when inspecting the newly inserted rows in the table, I need to be able to associate each row with the BCP command that [...]

Answer Question   |  September 12, 2008  5:43 PM
BCP Utility

bcp utility in sql server 2005
hi,how to send logins from server to another server using bcp utility.

Answer Question   |  July 8, 2010  5:51 AM
BCP Utility, SQL Server 2005