• 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"