Greetings,
I need to programmatically grab the name of the executing package so that it can be used in logging. Does someone have a code sample for this?
Thanks!
Use the system variable, PackageName.|||Thanks.
For those who may benefit from a code sample:
Dim source AsString
Dim vars As Variables
Dts.VariableDispenser.LockOneForRead("System:ackageName", vars)
source = vars("PackageName").Value.ToString()
|||Also the other options (perhaps not for this example) are to use a derived column to add the system variable to the data flow, or in the control flow, using an Execute SQL task, you can map the variable to a parameter in the SQL statement.
No comments:
Post a Comment