i am doing a bulk insert: DECLARE @row_terminator CHAR; SET @row_terminator = CHAR(10); — or char(10) DECLARE @stmt NVARCHAR(2000); SET @stmt = ‘ BULK INSERT accn_errors FROM ”F:FullUnzipped…
Tag: bulkinsert
Bulk load data conversion error (truncation)
I am getting this error Bulk load data conversion error (truncation) for row 1, column 12 (is_download) here is the csv…it only has one row 30,Bill,Worthy,sales,,709888499,bat@bat.com,,”Im a a …
SqlBulkCopy from a List
How can I make a big insertion with SqlBulkCopy from a List of simple object ? Do I implement my custom IDataReader ?
SQL Bulk Insert with FIRSTROW parameter skips the following line
I can’t seem to figure out how this is happening. Here’s an example of the file that I’m attempting to bulk insert into SQL server 2005: ***A NICE HEADER HERE*** 0000001234|SSNV|00013893-03JUN09 …