<div>
is your text file having string of only 3 char or less character after 12 &quot;,&quot; (comma)?<br />
check it.or attached sample of your txt file..<br />
<br />
Thanks,<br />
Nishant
</div>


is your text file having string of only 3 char or less character after 12 "," (comma)?
check it.or attached sample of your txt file..

Thanks,
Nishant

<div>
<div class="content wysiwyg-content">
I have another problem. I am getting a truncation error for:<br />
<br />
BULK INSERT PATRONLOADZETA2 FROM 'c:\patrondata\PATRONLOADF<wbr />ORILLIAD4.<wbr />txt' WITH (FIELDTERMINATOR=',',ROWTE<wbr />RMINATOR='<wbr /> ' ) <br />
<br />
It is saying Column 13 has bulk conversion error<br />
<br />
Column 13 HAS PROPERTIES: (varchar(3),NULL)<br />
i am simply inserting the string: &nbsp;YES <br />
I the input file the field appears correct &nbsp;,YES,<br />
(WITH NO QUOTATION MARKS)<br />
<br />
I am perplexed.
</div>
</div>


I have another problem. I am getting a truncation error for:

BULK INSERT PATRONLOADZETA2 FROM 'c:\patrondata\PATRONLOADFORILLIAD4.txt' WITH (FIELDTERMINATOR=',',ROWTERMINATOR=' ' ) 

It is saying Column 13 has bulk conversion error

Column 13 HAS PROPERTIES: (varchar(3),NULL)
i am simply inserting the string:  YES 
I the input file the field appears correct  ,YES,
(WITH NO QUOTATION MARKS)

I am perplexed.

MSSQL BULK INSERT PROBLEM

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.