Creating Dynalic Excel Files With DTS

[yhareesh]

I want to write a DTS Package that creates ones excel file for each record.
I usually used the DTS to export to existing excel file, bot not to a file
with dynamic name.
Please give me a better clue.

[Moby]

if you still use the (old) dts from sql2000 you can change the file
name dynamicaly by the task "dynamic properties"
there you have different way's (ini-file, select, global variable,
etc), how to change the file name (and path),

kr moby