Steve
Hi Steve, I ment something like this:
truncate table infile_list
set @v_commandline = 'dir /B ' + @v_processeddest + '*.unl'
insert into infile_list
exec @result = master..xp_cmdshell @v_commandline
Where ive sent the output of the xp_cmdshell to a table for later processing.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"