Hi Everyone,
I have the following sql statement that Bulk Inserts a .iff file from a folder. It looks like this.
BULK INSERT Received
FROM '\\Admfs1\users\CPurnell\Responses\C0009344.iff'
WITH
(
FIELDTERMINATOR ='|',
ROWTERMINATOR =' {CR}{LF}\n'
)
This works great for one file. What I really need is to bulk insert all .iff files from the Responses folder. Something like this.
BULK INSERT Received
FROM '\\Admfs1\users\CPurnell\Responses\%.iff'
WITH
(
FIELDTERMINATOR ='|',
ROWTERMINATOR =' {CR}{LF}\n'
)
Is there a way to do this in a sql statement?
Thanks for your help!
I have the following sql statement that Bulk Inserts a .iff file from a folder. It looks like this.
BULK INSERT Received
FROM '\\Admfs1\users\CPurnell\Responses\C0009344.iff'
WITH
(
FIELDTERMINATOR ='|',
ROWTERMINATOR =' {CR}{LF}\n'
)
This works great for one file. What I really need is to bulk insert all .iff files from the Responses folder. Something like this.
BULK INSERT Received
FROM '\\Admfs1\users\CPurnell\Responses\%.iff'
WITH
(
FIELDTERMINATOR ='|',
ROWTERMINATOR =' {CR}{LF}\n'
)
Is there a way to do this in a sql statement?
Thanks for your help!