Hi,

I finally got the DTP package up and running:

- it runs the query
- saves it as a txt file to the local server
- ftp's it to a remote server

I just found out that the txt file has to be unique and follow a certain
format:

MIOsampleYYYYMMDDHHMM

MIOsample = always the same
YYYY = Year 2005
MM = Month 08
DD = Day 08
HH = 24-hour clock (military)
MM = minutes

I saw a mention of using "Dynamic Properties Task" but have no idea how to
use it or were to put it.

Any help would be greatly appreciated.

Thanks,

Mitch

In message <uP9rxq2nFHA.1372 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, mitch
<mitch_001 (AT) REMOVEyahoo (DOT) com> writes
will have to be an ActiveX Script Task. Try something like this-

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