Hi, I BCP'd some data out from a table into a ~ delimited text file.
I now want to Bulk Insert the data back into the original table structure.
BULK INSERT amastact FROM 'D:\Downloads\AssetTables\amastact.txt' WITH (FIELDTERMINATOR = '"~"')
However the first column in the table is a timestamp
and I get this error
OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.].
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.
Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.
Is this due to the first column being a timestamp column? and any ideas how I make it work?
I now want to Bulk Insert the data back into the original table structure.
BULK INSERT amastact FROM 'D:\Downloads\AssetTables\amastact.txt' WITH (FIELDTERMINATOR = '"~"')
However the first column in the table is a timestamp
and I get this error
OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.].
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.
Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.
Is this due to the first column being a timestamp column? and any ideas how I make it work?