FTP file create date

[junho]

Hi,
I am downloading files from remote FTP server to import data into tables via DTS FTP task, then archive the files into a folder, etc. It works fine without any problems.

However, I would like to capture the "file created date" of the file on the FTP server. To be more specific...

This is what it shows about the file on remote FTP server.
File 2050301Sale.csv 3/1/2005 12:02 AM

If I use the FTP task of DTS of above file on 3/1/2005 3:00 AM, then the file on the SQL box shows...

File 2050301Sale.csv 3/1/2005 3:00 AM

Anyways to bring in the 12:02 AM part instead of over-writing it with whatever the current time?

Thanks,
Junho

 

[dbomrrsm]

Not 100% sure but maybe you can declare a variable and set it to the name of the file on the remote server if you can in some way pull that seperately.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]