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 |
|
thanksfor help
Posting Yak Master
106 Posts |
 Posted - 2005-07-15 : 19:46:05
|
| I am getting following error when I bulk insert.Any help is very much appreciated.String or binary data would be truncated.The statement has been terminated.thanks |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-07-16 : 00:20:56
|
| Well, there could be many things causing this problem. The basic problem is that some data is too long for at least one of your columns. If you're lucky, all you need to do is make that column wider. A lot of times, the problem is a missing column delimiter for a row, or too many column delimiters. For example, if your data is supposed to be tab delimited, and if some of your data unexpectedly has tabs within the columns, then the data will be inserted into the wrong columns. Trying to find out what data is causing the problem is not so easy. Probably the first step to take is to create a new table with very wide columns so that the bulk insert can work without errors. Then query the table to find out what data is either unexpectedly long or in the wrong position. |
 |
|
|
|
|
|
bulk insert error