I currently have a DTS that takes a view and exports it to a file called
purolator.csv on a network drive every 10minutes from 9am to 10pm
everyday.

I need to get that package to generate different filenames everytime it
runs, 7 days at a time..
purolator1.csv
purolator2.csv
etc....then after 7 days it comes back to 1...anyone has an idea ?

Have a look at this and see if you can tweak for your needs

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

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Fred Smith" <fredsmith (AT) aliencow (DOT) com> wrote