I need to DTS a text file that is placed up on our
network and named file.daily.20031104 (today's date) How
do I get DTS to grad that file since everyday it has a
different name? Someone told me to set up a stored proc
that renames that file first...then let DTS grab it, then
rename it back to the original name and then archieve it.
Any ideas?? Thanks!

I am not 100% sure, but I would do it this way -

1. Create a GlobaVariable FileName of type string.
2. Create a ActiveX task that actually updates this Global
Variable to the right filename ie. file.daily. + getdate().
3. Create a Connection object (e.g C1) to the Text File,
and the connection properties could be updated easily.

Dim oConn
Set oConn = DTSGlobalVariables.Parent.Connection("C1")
oConn.DataSource = CONCATINATED STRING (file.daily. +
getdate()

I think this should do it.

In article <062901c3a353$77e53930$a501280a (AT) phx (DOT) gbl>, Rich London
<anonymous (AT) discussions (DOT) microsoft.com> writes

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

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

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