Hi all,
Maybe my doubt is very simple, but i did't find references how to solve this
problem that in SQL 2000 I've used dynamic properties.
The objective is to create a text file destination based in a query. But
each time that the package runs I want to create a file based on the actual
date.
In SQL 2000 I solved this problem using a dynamic property task that set up
the Data Source package property with a simple query: select
'C:\filename_'+convert(varchar(8),getdate(),112)+' .dat'. In this way the DTS
runs each day and will create a file based in the actual date.
In SQL 2005 the dynamic properties task doesn't exist. I thought that this
kind of things could be very simple to configure in SSIS. Maybe it is, but I
have to confess that I couldn't find this in the documentation...
Any idea??
Thank you very much

Alexandre Calderaro

MSCDBA - Avanade Italy

Hello alex,


Expressions have replaced the Dynamic Properties Task, or rather removed
the need for it.

Set an expression on the connection string property of the file connection.

Some sample date expressions can be found here-

Expression Date Functions
(http://wiki.sqlis.com/default.aspx/S...Functions.html)

Thanks Darren,

Your answer is very helpful, although I'd already find a similar expression.
Unfortunately I think that the books online for SQL 2005 is not yet very
easy to find the solution. I tried some expressions samples that did'nt
work...
Regards

Alexandre

"Darren Green" wrote: