I am trying to use the BULK INSERT command and keep getting this error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
The statement has been terminated.
The exact command i am using is:
BULK INSERT TestDB..Contacts FROM 'C:\ContactsImport.txt'
WITH (FORMATFILE = 'C:\bcp.fmt')
But i can use the bcp command form dos just fine using the same files. Any Ideas?
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
The statement has been terminated.
The exact command i am using is:
BULK INSERT TestDB..Contacts FROM 'C:\ContactsImport.txt'
WITH (FORMATFILE = 'C:\bcp.fmt')
But i can use the bcp command form dos just fine using the same files. Any Ideas?