See Re: Code to do an ADIR() Message #687244.

>We are trying to use SQL Server xp_cmdshell SP to retireve directory information using a 'DIR xxx.*' type command. This returns a result set in Query Analyzer with an nvarchar(255) column named 'output'. However, we have not been able to find documentation on how to run the command in a SP and force the result set into, say, a temporary table in order to manipulate the data. How would this be done?
>
>Thanks,
>Bill