I Have an txt file as below :
from the data I want to import into my table with same field name (date, trans_id).
I try import the data with the task menu, import data and it is work.
Next way I want to import it by sql syntax such as :
SET IDENTITY_INSERT bcode ON
BULK INSERT bcode FROM 'd:\bcode\barcodewhr2.txt' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR ='\r\n') ;
SET IDENTITY_INSERT bcode OFF
but there's an error said " Table 'bcode' does not have the identity property. Cannot perform SET operation."
the table destination don't have a primary key it just temporary table.