Import different files but same type of data

#1

Hi,
I am trying to import text file into a table and that file name changes
every night. The file name is solely based on the day and date of the
previous day. Is there a way to specify, in DTS, some method by which the dts
automatically knows what file to pick as an import based on the system date?
Thanks.
IMRAN

#2

Have a look here

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

And here

Looping, Importing and Archiving
(http://www.sqldts.com/Default.aspx?246)
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"Imran Prasla" <ImranPrasla (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,
I am trying to import text file into a table and that file name changes
every night. The file name is solely based on the day and date of the
previous day. Is there a way to specify, in DTS, some method by which the
dts
automatically knows what file to pick as an import based on the system
date?
Thanks.
IMRAN

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

Import different files but same type of data

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

Import different files but same type of data - 10-13-2004 , 10:29 AM

Re: Import different files but same type of data - 10-13-2004 , 12:33 PM