Windows Batch script and SQL

[747576]

Hi,

Is it possible to have sql return a comma separated list (string) of file names that exist in a folder.

This can be done using a batch command script or VBScript, it will be return the file names in a specified folder, but how do I incorporate this into an sql statement or sql sp.

Thank you

 

[Crowley16]

are you using 2000 or 2005?

In 2000 I believe there's xp_dir but can't confirm.

I can't seem to find an equivalent in 2005 so you'll have to use xp_cmdshell, this will need to be turned on, and be aware of the security implications of this.

of course, if you want a comma delimited list, then you'll have to build it from the results.

--------------------
Procrastinate Now!

 

[markros]

I just tried EXEC master..xp_dirtree 'C:\Documents and Settings' and it seems to return files as well with 11 as depth.

See

http://www.sql-server-performance.com/articles/dev/extended_stored_procedures_p1.aspx