Create Procedure [dbo].[MySP]
@MyFile nvarchar(200)
AS
exec('BULK INSERT MyDB.[dbo].[MyTable] FROM '+@MyFile+' WITH
(
CHECK_CONSTRAINTS,
FIELDTERMINATOR = '','',
ROWTERMINATOR = ''\n'',
FIRE_TRIGGERS
)')
@MyFile nvarchar(200)
AS
exec('BULK INSERT MyDB.[dbo].[MyTable] FROM '+@MyFile+' WITH
(
CHECK_CONSTRAINTS,
FIELDTERMINATOR = '','',
ROWTERMINATOR = ''\n'',
FIRE_TRIGGERS
)')
FROM '+@a+'
WITH
(
CHECK_CONSTRAINTS,
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRE_TRIGGERS
)')