MS-DOS COPY problem

Hi,
I want to create a batch file which copies existing files in one directory to another directory(actually sub-directories in the second directory) based on the dates they were created using MS-DOS command.
Example:
File A created on Jan-10-03
File B created on Dec-12-97
File A & B are in C:/ drive and when I run the batch file the File A should be copied to d:/Jan & File B should be copied to D:/Dec

Please let me know!
Thanks.Use xp_cmdshell ...|||Could you please elaborate...I am kind of new to the IT field.
Thank you.

Originally posted by snail
Use xp_cmdshell ...|||xp_cmdshell allows you to issue commands to the operating system just as if you were at a DOS prompt. xp_cmdshell must be called from the Master database. Look it up in Books Online for syntax and details.

blindman|||Doing this with CMD commands is going to be tuff. For this type of work I would suggest a scripting language like PERL, PYTHON or even good old qbasic! Of course you could do this with TSQL but this is not always the best solution for system scripting. Knowing one of the above languages will make short work of this kind of task.|||Hi,

another possibility would be an ActiveXScript in a DTS package. For information about working with files in DTS refer to http://www.sqldts.com/default.aspx?292

Bye,
Carsten