bcp command is replacing empty strings with nulls

Using BCP, you may write from a SQL Server table to a file.

FYI for anyone else.... ...bcp "Select whatever from dbInstanceName.dbo.tableName" quesryout C:\output.txt -e C:\errors.txt -c -T -S localhost\dbName

String conversion is refused by SqlBulkCopy. INT NULL is empty.

Recently I've been tasked with creating an automated ETL process that pumps the data into tables based on the flat file name by reading a master mapping file. I've decided to go with SqlBulkCopy and everything seemed to be fine. IDataReader interface was implemented to read flat-files, SQL Server's meta-data provided with number of columns for a on...

bcp command execution incoherence

I execute a bcp command in 2 computer. The first computer has windows xp and second one has windows server 2003. when I execute command in first, the bcp run successfully but when I run this on second one, occur this error:...Starting copy... SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 720 is n...

Is SqlServer BCP all or nothing?

We have some critical code that relies on the .NET SqlBulkCopy API. Occasionally, this code will fail with the following error:...System.Data.SqlClient.SqlException : Insert bulk failed due to a schema change of the target table....This blog post... suggests that this is a transient, nearly unpreventable error. What I'm wondering is, when this erro...

Skip host file column in bcp format file Sybase

I have a csv texte file like this : ...SicID;PorID;FarId;Company;DecadeId;SocName;FarName A1;A2;A3;A4;A5;A6;A7 B1;B2;B3;B4;B5;B6;B7 C1;C2;C3;C4;C5;C6;C7 ...I want to use Bcp Sybase to import this file in my_table but only the SicID, PorID and SocName. So I use this bcp format file :...10.0 8 1 SYBCHAR 0 2 ";" 1 SicId 2 SYBCHAR 0 2 ";"...

C# - Importing a CSV where empty strings do not get sent through bulk import to database

There are a multitude of solutions to get where you need....One problem I see is that if the person is uploading items with multiple rows and those rows have different data (say one column is blank on one row but filled in on a second row), that will cause it to break since the column will have deleted itself....SITE32,,1,2,,... SITE32,1,2,,,... ..

LINQ: Convert any empty string to Null

I have a list populated with massive amount of data and over hundred columns. I will have to convert the entire list to DataTable and use ...SQLBulkCopy... to batch insert all data into the database. ...Everything is okay except that some of the fields could be empty. And for some reason, some of the empty fields causes some formatting exception af...

Microsoft SQL BCP Format File - Version?

I have a question regarding Microsoft SQL's Bulk Copy Program (BCP.exe). I am relatively new to using the program so am hoping it's an easy question for some, however I am stuck!...On Server #1 we're running Microsoft SQL 2014, it runs the BCP to export a number of tables. It provides me with a *.DAT and *.FMT file per table....When I go to import ...

SAS with BULKLOAD=Yes: ERROR: BCP initialize error: Unable to retrieve error message

Has anyone encountered the error when trying to run in any of the bulk modes (not just bulkload=yes, but also insertbuff=xxx etc). The related odbcbcp.dll is present in the System32 directory, so this is not the case of being unable to find it....Runs fine w/out bulk load, but of course the speed is not even close....SAS 9.3, Win 32-bit

Troubleshooting BCP and Format File Errors

First off, sorry for the long post. I wanted to be thorough with my examples/data, and the bulk of this post is just that....I inherited a Bulk Import Process using a format file (.fmt) at my new job. This process was created by the guy that worked here before me, and it is my job to learn this process (and fix it now). I have limited knowledge ...