Writing SSIS Variable Variables

Question

I upload about 40 files to Oracle from my SSIS ETL package. At the end of each file upload process, I run an SQL query to perform a type 2 update to expire old data.

SQL Query is stored in a variable with a name ExpireOldRecordsQuerythat is built at run time, so the property is EvaluateAsExpressionset to a value TRUE, and the expression looks something like this:

"Update MyTable Set ExpiredOn = SYSDATE Where ExpiredOn IS NULL AND DownloadID <> " + @User::CurrentDownloadId

I want to write the actual request from a variable ExpireOldRecordsQuery.

How do I make SSIS log, what is the expression evaluated for?

Answer 1

, , . , ExpireOldRecordsQuery @User:: CurrentDownLoadId.

ExpireOldRecordsQuery , . SSIS, FireInformation() Script SSIS.