I am loading about 40 files to Oracle from my SSIS ETL package. At the end of each files load process, I run a SQL query to to perform a Type-2 update for old data expiration.
The SQL Query is stored in a variable called
I want to log the actual query from the
How do I make SSIS log what the expression is evaluated to?
note: cross posted here
You can eg configure internal SSIS logging feature.
And you have logging implemented. You will see in the log what query was executed even it is build dynamicaly or read from variable etc.
You can also implement youw own loggin eg. by implementing EventHandler for PreExecute, PostEvecute, PostValidate etc.. depending when you want the logging to occure. Put a script task into the event handler and write your own logging iside the script.
There are many ways of how to accomplish this, but I think, the internal logging is the optimal one.
answered Nov 18, 2010 at 09:31 AM