Dynamically change Output Files

#1

Can you dynamically change the names of (text output files) . I have a
datapump task that exports to 7 different output files. I would like to
change the names of these files based upon the date/time I run the process.

#2

You certainly can

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

"Hoosbruin" <Hoosbruin (AT) Kconline (DOT) com> wrote

Quote:

Can you dynamically change the names of (text output files) . I have a datapump task that exports to 7 different output files. I
would like to change the names of these files based upon the date/time I run the process.

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

Dynamically change Output Files

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

Dynamically change Output Files - 04-25-2005 , 05:56 PM

Re: Dynamically change Output Files - 04-26-2005 , 12:54 AM