Home Forums SQL Server 7,2000 General Rename a text file, move it, using a stored procedure RE: Rename a text file, move it, using a stored procedure

  • I'm getting closer:

     

    EXEC master..xp_cmdshell 'REN C:\ImportData\ImportData.txt ImportData1.txt'

    EXEC master..xp_cmdshell 'MOVE C:\ImportData\ImportData1.txt C:\ImportData\Finished\ImportData1.txt'