SQL Server 2012 SSIS - variable expression from execute sql task

0
votes

SQL Server 2012 SSIS

I have an expression stored in a table column that is retrieved by an execute sql task.

Expression: "Report Name as of"+" " + Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2)+"/"+ Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) +"/"+ (DT_STR,4,1252) DatePart("yyyy",getdate())

I have no problem getting that into a variable, but I want the evaluation of the expression in a variable, not the expression itself. I've spent about 5 hours today on this. If anyone has any idea I'd greatly appreciate the knowledge.

Thank you in advance!

Craig

1
sql-server-2012ssis
Do you mean EvaluateAsExpression? - GSerg

1 Answers

1
votes

set EvaluateAsExpression=TRUE in variable property.

Please note - if you assign an expression to the variable, and EvaluateAsExpression is set to True, you cannot change the variable data type