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 |
|
aakcse
Aged Yak Warrior
570 Posts |
 Posted - 2010-03-25 : 14:48:23
|
| SELECT a.* FROM OPENROWSET (BULK 'c:\Projects\Cleaned.txt',FORMATFILE = 'c:\Projects\format.txt',MAXERRORS = 999999999, ERRORFILE = 'c:\Projects\error.txt')AS aI am getting error for this, can any one helpI have a file cleaned.txt, I have created format.txt(blank file)Trying to run the above command.It is giving syntax errorMsg 9435, Level 16, State 48, Line 2XML parsing: line 1, character 0, one root element |
|
|
|
|
|
OPENROWSET help needed