|
The following short TSQL will read files from disk into a table.
The example below will read all the files from the root of the C directory into a local table, but if you remember your DOS commands the path could be set to read any types of files from anywhere. The /B at the end of the DIR command is important as it returns only the filename with none of the other information like filesizes and attributes.
declare @dos varchar(255)
declare @fl table(filename varchar(255))
set @dos='DIR C:\*.* /B'
insert into @fl(filename)
exec xp_cmdshell @dos
select * from @fl where filename is not null
The select statement reads all the files listed, but it could easily be made more specific to get files matching a specific pattern if needed.
If this does not work on your system, then XP_CMDSHELL might not be enabled, see the other article in the knowledgbase.
|
04 August 2009 IB
SQL Server
|
Back To List
Did this article answer your question |
 |
Yes |
 |
No |
|
Other items of interest in our knowledgebase
|
