DTS: make the txt file name unique using a certain format

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS: make the txt file name unique using a certain format

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-16 : 08:04:14

Mitch writes "Hi,

I finally got the DTP package up and running:

- it runs the query every hour
- 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"

lizak
Starting Member

12 Posts

Posted - 2005-08-16 : 12:18:50

It's a lot easier to use the Dynamic Properties Task than you might think. Basically you add it to the package and it exposes all the different settings and values in the package. You can then select the appropriate setting and define where and how you want it's value to be determined. It's really very handy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources