I am trying to use a Dynamic Properties task for the first time.
I have a DTS Package containing a transform data task which outputs to a file named "\\servername\folder\xxxxxx.csv".
I have set up a dynamic properties task which uses a query
SELECT '\\servername\folder\'+REPLACE(CONVERT(varchar(10),getdate(),3),"/","")+'.csv'
to try to set the above filename (DataSource property) to use today's date.
However, it appears to have no effect, and the results are still output to \\servername\folder\xxxxxx.csv .
I have now also set up the same query for the property DestinationObjectName on the DataPumpTask, but that didn't change anything.
What do I need to do to force the dynamic properties to be used?
I have a DTS Package containing a transform data task which outputs to a file named "\\servername\folder\xxxxxx.csv".
I have set up a dynamic properties task which uses a query
SELECT '\\servername\folder\'+REPLACE(CONVERT(varchar(10),getdate(),3),"/","")+'.csv'
to try to set the above filename (DataSource property) to use today's date.
However, it appears to have no effect, and the results are still output to \\servername\folder\xxxxxx.csv .
I have now also set up the same query for the property DestinationObjectName on the DataPumpTask, but that didn't change anything.
What do I need to do to force the dynamic properties to be used?