Friday, March 7, 2014

Bulk Insert

bulk insert dbo.TestTable from 'D:\SSISFiles\Test.csv'
with (
firstrow = 2,
FIELDTERMINATOR = ',' ,
ROWTERMINATOR = '\n'
);
GO

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.