Hi,
Why you want to create INSERT script for each record? you can use BULK INSERT for single call of DataBase.
See the following Example
BULK
INSERT CSVTest
FROM 'c:\csvtest.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
Thanks,
Imdadhusen