Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abuhassan
105 Posts |
 Posted - 2006-12-04 : 12:26:38
|
| hi "Bulk insert data conversion error (truncation) for row 1, column 1 (id)."when you get the error above or similar in sql server 2000 does it continue inserting the data by truncating it or does it stop beacause looking at the data that i have got it seems to continue inserting the data but just truncates the colunm. i have tried it several time its seeems to be consistent. I have data that has white spaces after the actual data e.g. '00093 ' hence i am happy aslong as i can be sure that it does always continue as i will be loading alot of data using a similar process. hence my question is that will it load all the data all the time and just truncate it to fit the column size? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-12-04 : 19:48:05
|
| It's an error so should stop when it reaches your error tolerance - think the default is 5.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
abuhassan
105 Posts |
Posted - 2006-12-06 : 09:43:11
|
| How can i increase or switch off the default error tolerance? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-06 : 09:52:04
|
| Increase you destination table column widths to accomodate the imported data.Peter LarssonHelsingborg, Sweden |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-12-06 : 09:55:55
|
| There's a maxerrors value you can include.Have a look in bol.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
abuhassan
105 Posts |
Posted - 2006-12-06 : 10:45:05
|
| Thanks for that Ive added the maxerrors to 50000 that workedi just wanted to ask if i didi the following i.e. "Increase you destination table column widths to accomodate the imported data." and then reduced to the original will that automatically truncate the colunms? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-06 : 10:50:14
|
| After importing, adjust your data with update yourtablenamehereset yourcolumnnamehere = rtrim(yourcolumnnamehere)and then insert into target tables.Peter LarssonHelsingborg, Sweden |
|
|
|
abuhassan
105 Posts |
Posted - 2006-12-07 : 11:50:36
|
| Many thanks |
|
|
|
|
|
|
Bulk insert data conversion error (truncation)