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
texpic
SSCertifiable
Points: 5885
More actions
May 1, 2005 at 12:36 pm
#556188
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'