CREATE TABLE table1 (

Field1 varchar(255),

Field2 datetime

)

and bulk insert query

BULK INSERT table1 FROM '<path>\xyz.txt' WITH (ROWTERMINATOR = '\n', FIELDTERMINATOR = '\t')

and content of xyz.sql

aa<Tab>getDate()