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 - 2001-07-23 : 09:33:15
|
| Joe writes "Is it possible for us to "massage" the data (parse, format, etc) while we are using the BULK INSERT command? Here is the problem: we receive a flat file with all the transaction data. We need to load this data into a table in our SQL Server 2000 DB, but before we do, we need to extract, format, and parse some of this data before we can load it into our table. Our solution: is to insert the data using BULK INSERT into a staging table. Then format, parse the data, and then Use BULK INSERT to insert the data into our transaction table. We would like to skip the step of placing it in a staging table and then inserting into the transaction table." |
|
|
|
|
|
BULK INSERT and Formating data