Is DTS source file's name parameterizable?

[athos]

Hi All,

We are using a DTS in SQL Server 2000 (will turn to 2005 soon, if
anything ad hoc may help) to import data periodically from a folder.

Now the problem is, if the filename is fixed. It makes it a little bit
troublesome to detect the date for data source -- we have to put the
date in the first row.

Is it possible, say, configue the DTS to fetch data from files like
DataYYYYMMDD.txt, so that, YYYYMMDD could be extract as an indicator as
the date of data source for the DTS?

Please help, thanks.

yours,
Athos.

[ZeldorBlat]

>Is it possible, say, configue the DTS to fetch data from files like

DataYYYYMMDD.txt, so that, YYYYMMDD could be extract as an indicator as
the date of data source for the DTS?

Yes -- check out "dynamic properties" in BOL.

[athos]

thanks!