Bulk Insert into Database – Dump your bulk data into Database

Bulk Insert in Database
Dump your bulk data files into Tables. Values of Row Terminator and Field Terminator changes according the requirement.

BULK INSERT DatabaseName.DBO .TableName
FROM 'Filepath'
WITH ( ROWTERMINATOR='END ROW' ,FIELDTERMINATOR= '^')

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *