Bulk Insert using a data table in C# - not rounding

• DanielP

  SSCrazy

  Points: 2323

  More actions

  November 28, 2007 at 3:00 pm

  #179569

  One of our developers is having an issue when trying to use Bulk Insert with a C# data table. The data that is being imported for example has a value of 6.246 into a SQL table of data type Numeric(18,2). It isn't rounding the value to 6.25 when inserting like it does via non-Bulk Insert - Inserts.

  Any suggestions on why it isn't rounding?

  thanks,

  Daniel