Hello Gurus,
I am using Sql Bulk INSERT, when passing the path directly it works, but it doen't works with parameter,
I have pasted the query below, Please help me with this.
working example
---------------------------
BULK INSERT master.dbo.Products2
FROM 'D:\Products.csv'
WITH
(
FIELDTERMINATOR=',',
ROWTERMINATOR='\n',
FIRSTROW=2
)
How to pass the path with parameter (need your help)
------------------------------------------------
Declare @Path varchar(100)
Set @Path = 'D:\Products.csv'
BULK INSERT master.dbo.Products2
FROM @Path --'D:\Products.csv'
WITH
(
FIELDTERMINATOR=',',
ROWTERMINATOR='\n',
FIRSTROW=2
)
Thanks in Advance
Go to the complete details ...