|
Execute the following
script in Query Editor create a stored procedure which reads a file folder to get the filenames:
use AdventureWorks
go
create procedure procReadFolder @path sysname
as
begin
set nocount on
declare @dirContent table(
id int identity(1,1),
FileName sysname NULL
)
declare @cmd nvarchar(512)
set @cmd = 'DIR /b ' + @path
insert into @dirContent
exec master..xp_cmdshell @cmd
select * from @dirContent
end
go
declare @path sysname
set @path = 'F:\data\export\'
exec procReadFolder @path
go
|