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 |
|
rahat
Starting Member
2 Posts |
 Posted - 2008-09-24 : 20:48:50
|
| Hi,I wanted to know is there any major difference between bcp engine 8 and 9. Because I am importing data from csv file with the same csv, format files and sql scripts but it looks like rows are not same in the imported tables. I am not sure if rows are dropped or not. but the total number of rows on 2 machines looks same. Though some rows and their values differs!!! Some table matches but in some tables the very first row does not match. Every time I execute the process, machines having bcp version 9 are having little different imported data than machines having bcp version 8.Thanx in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-25 : 01:43:07
|
| are your csvs consistent in format. do you have blank data in b/w? alsoare you using format file?Anyawys worth trying out after specifying a format filehttp://www.nigelrivett.net/SQLTsql/BCP_quoted_CSV_Format_file.html |
 |
|
|
rahat
Starting Member
2 Posts |
Posted - 2008-10-07 : 11:46:28
|
| Yes I am using format files and there are null values in the csvs imports. I am not sure what u meant by 'consistent'. |
|
|
|
|
|
|
BCP version and Imported rows sequence