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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-08 : 08:19:42
|
| MSNaidu writes "There is a csv file with 5 columns. I need to load this file into SQL. While loading into SQL, I need to modify the data in column 4of the csv itself(which had data in Hex format, need to convert it to an int while insert into SQL - Eg if data is 000000C0, then insert 192 etc...). Can I use Bulk Insert in this case.I did the normal way of loading the data from the file into SQL by modifying the data, row-by-row, But it takes a long time for inserting data. (Typical data tested is for 31000 lines of insertion from csv file to SQL, it took about 1 min and 20 sec). This was just a test data and the customers would have much moredata than this and it would not be accepted to consume time for loading data (as this is related to the running power/thermal plants).Any thoughts on this..?" |
|
|
|
|
|
Can Bulk Insert be used if you need to modify a column data