Add a date to the export of a flat file with Dynamic porperties

#1

Can I add the date to the file name when I export SQL data using a Dynamic
Properties task.

LP

#2

I would probably use this method

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 - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"LP" <LP (AT) discussions (DOT) microsoft.com> wrote

Quote:

Can I add the date to the file name when I export SQL data using a Dynamic
Properties task.

LP

#3

Thanks,

This will make another part easier also.

LP

"Allan Mitchell" wrote:

Quote:

I would probably use this method

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 - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"LP" <LP (AT) discussions (DOT) microsoft.com> wrote in message
news:BBFF3455-4152-41FC-9A6E-6887A8751782 (AT) microsoft (DOT) com...
Can I add the date to the file name when I export SQL data using a Dynamic
Properties task.

LP

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

Add a date to the export of a flat file with Dynamic porperties

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

Add a date to the export of a flat file with Dynamic porperties - 01-28-2005 , 01:19 PM

Re: Add a date to the export of a flat file with Dynamic porperties - 01-29-2005 , 01:02 AM

Re: Add a date to the export of a flat file with Dynamic porpertie - 01-31-2005 , 08:09 AM