Creating Dynalic Excel Files With DTS

#1

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.

#2

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Creating Dynalic Excel Files With DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Creating Dynalic Excel Files With DTS - 01-22-2009 , 01:49 PM

Re: Creating Dynalic Excel Files With DTS - 01-23-2009 , 07:49 AM