Getting timestamp of flat files

#1

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

#2

In message <1121978388.965694.202690 (AT) f14g2000cwb (DOT) googlegroups.com>,
kayda <tabladude (AT) gmail (DOT) com> writes

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Getting timestamp of flat files

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Getting timestamp of flat files - 07-21-2005 , 03:39 PM

Re: Getting timestamp of flat files - 07-21-2005 , 05:20 PM