edurgynoinfurry
New Member
I want to insert a \[code\]bulk\[/code\] of data into \[code\]sql server\[/code\]. \[code\]DOB\[/code\] is a date column; using the following code :\[code\] Using connection As New SqlConnection(connString) connection.Open() 'Open bulkcopy connection. Using bulkcopy As New SqlBulkCopy(connection) 'Set destination table name 'to table previously created. bulkcopy.DestinationTableName = "Staff" bulkcopy.ColumnMappings.Add("Id", "Id") bulkcopy.ColumnMappings.Add("Name", "Name") bulkcopy.ColumnMappings.Add("Location", "Location") bulkcopy.ColumnMappings.Add("DOB", "DOB") bulkcopy.ColumnMappings.Add("Gender", "Gender") bulkcopy.ColumnMappings.Add("Post_No", "Post_No") bulkcopy.ColumnMappings.Add("Post_Title", "Post_Title") bulkcopy.ColumnMappings.Add("OCC", "OCC") bulkcopy.ColumnMappings.Add("Station_Desc", "Station_Desc") bulkcopy.ColumnMappings.Add("Grade", "Grade") bulkcopy.ColumnMappings.Add("sec_no", "sec_no") bulkcopy.WriteToServer(ds.Tables(0)) bulkcopy.Close() connection.Close() End Using End Using\[/code\]I got the following error : \[code\] String or binary data would be truncated. \[/code\]