Renaming the file after DTS package execution

[Ramam]

Hi,
After executing a dts package to load data from a file to a SQL table. I need to rename the file after the load.
Could any one give me a code sample so that I can add that as a task after the execution of the load in the same package

Ramam

[Ray Miao]

Use xp_cmdshell to call ren.


------------
Ramam at 11/1/00 1:47:48 PM


Hi,
After executing a dts package to load data from a file to a SQL table. I need to rename the file after the load.
Could any one give me a code sample so that I can add that as a task after the execution of the load in the same package

Ramam

could you just give usage of xp_cmdshell to rename a file ?
I wanted to give this as a task on success of my loadtask in a package

Ramam

------------
Ray Miao at 11/1/00 1:50:05 PM

Use xp_cmdshell to call ren.


------------
Ramam at 11/1/00 1:47:48 PM


Hi,
After executing a dts package to load data from a file to a SQL table. I need to rename the file after the load.
Could any one give me a code sample so that I can add that as a task after the execution of the load in the same package

Ramam

[Ramam]

I have tried using the xp_cmdshell command. It is not giving any errors but the the renaming is not happening.
the code I used is
master..xp_cmdshell 'ren c:
eadme.txt c:1234.txt'

Ramam

------------
Ramam at 11/1/00 1:47:48 PM


Hi,
After executing a dts package to load data from a file to a SQL table. I need to rename the file after the load.
Could any one give me a code sample so that I can add that as a task after the execution of the load in the same package

Ramam