MS SQL Server DTS - Getting timestamp of flat files

Author

Getting timestamp of flat files

kayda

2005-07-21, 8:24 pm

Hi there:

I am going to be pumping data from text files via ODBC into SQL via
DTS. Is it possible through something like an ActiveX script task to
get the timestamp on th e flat files? Basically there are separate flat
files that get created every 30 minutes. My DTS will read from the new
flat file (using code to figure out the timestamped name of the file).
But I may want to look at old files if new version s of the old files
have been created, which might happen. If not, I'll leave them alone.

Thanks,
Kayda

Darren Green

2005-07-21, 8:24 pm

In message <1121978388.965694.202690@f14g2000cwb.googlegroups.com>,
kayda <tabladude@gmail.com> writes
>Hi there:
>
>I am going to be pumping data from text files via ODBC into SQL via
>DTS. Is it possible through something like an ActiveX script task to
>get the timestamp on th e flat files? Basically there are separate flat
>files that get created every 30 minutes. My DTS will read from the new
>flat file (using code to figure out the timestamped name of the file).
>But I may want to look at old files if new version s of the old files
>have been created, which might happen. If not, I'll leave them alone.
>
>Thanks,
>Kayda
>

There's an example in here-

Working with files and the FileSystemObject
(http://www.sqldts.com/default.aspx?292)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Sponsored Links