Posted by athos on 11/15/05 02:57

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.

• Next in forum: Re: SQL server connection problem
• Prev in forum: Re: who knows reporting service
• Thread view: Is DTS source file's name parameterizable?

[Reply to this message]