/* Data File Bulk Insert */
Use Demo_Database

Bulk Insert Demo_Database.dbo.[Customer]
 From 'E:\Database_Data\Demo-Database_Customer_Datafile.txt'
 With (
  Batchsize = 9,
  Datafiletype = 'Char',
  Fieldterminator = ';',
  Rowterminator = ','
  )
Go