I'm trying to create a DTS package that imports a CSV file into a table
in a database on SQL Server 2000 sp3a. I've got it set up so that it
successfully imports the file. The problem comes in because that
filename changes daily. The filename is "SQLCounters_[today's
date}.csv". How can I tell my DTS package to increment the date portion
of the filename by 1 (or to use getdate() -1 since the package will be
actually be run the day after the file is created)?

Is there a good DTS reference book or site for a DTS beginner?

I hope that makes sense.
Thanks for any help.

Toni

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In message <#9PyXB2PEHA.1840 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Toni
<teibner (AT) nospam (DOT) allina.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