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 |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2009-07-25 : 22:49:19
|
| Is there any other option to read directly from flat file other than OpenRowset as OpenRowset doesnt work in our 64 bit Sql 2005... I need to use that to read CSV flat file with embedded comma in the data...thanks for help. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-26 : 00:26:35
|
BCPSSISBULK INSERTWhat is the error message you get when using OPENROWSET? Remember that the path to the file is relative your seever, not your workstation.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
Openrowset to read from flat file