July 13, 2016 at 11:45 am
Folks
Look at the file attached.
I have highlighted ( in the pic ) the value of that is in the variable.
I want to Replace the YYYYMMDD part with the current date.
Help please with building the expression.
July 13, 2016 at 11:52 am
What is the definition for the Member parameter?
July 13, 2016 at 12:07 pm
It is a parameter of type string. It has a path and name of the output file.
So the value of this variable will be used by the ConnectionString property.
July 13, 2016 at 12:09 pm
See the attached, If that helps you.....
July 13, 2016 at 12:35 pm
Try this.
REPLACE(@[$Project::MEMBER], "YYYYMMDD",REPLACE((DT_WSTR, 10)(DT_DBDATE)GETDATE(),"-","") )
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply