I would recommend to check if the file is empty first
before execute the bulk insert. Obviously, it seems to
have problem if it can't find any terminator characters.
You can use VBScript to check whether the file is empty
and according with the result, you execute the next
MCSD, MCDBA, MCSE, MCP+I
data from a text file
the bulk insert text
bombs out with the [/ref][/ref]
for row 1, column [/ref][/ref]
provider did not give any [/ref][/ref]
char. DataFileType [/ref][/ref]
IRowset::GetNextRows returned [/ref][/ref]
about the error.]. [/ref]
>How do I overcome this error?