SQL for bulk insert into a table:
BEGIN
declare @s varchar(400)
set @s = ‘BULK Insert my_temp_table FROM ”’
+ @file_name + ”’ WITH (
FIELDTERMINATOR = ”,”,
ROWTERMINATOR = ”\n”,
FIRSTROW = 1
)’
print @s
exec(@s)
END
Zahid's blog on Data Engineering and BI 