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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2010-08-13 : 12:49:32
|
GreetingsI am doing some bcp using query to .dat files and then BULK INSERT to my staging tables. It BULK INSERTs fine but then after few thousand rows I get an error Msg 4832, Level 16, State 1, Line 5Bulk load: An unexpected end of file was encountered in the data file. . When looking at the table it inserted into, it seems like items from first row are spilling over into second row and so on and so forth. I am suspecting the source table rows might have some carriage return, line feed, tabs etc, is that even possible? When doing the same bcp to csv and then BULK INSERT using a format file all is well. How can check to see what anomalies are causing my problem with .dat file?ThanksIf you don't have the passion to help people, you have no passion |
|
|
|
|
|
bcp to .dat vs bcp to csv