Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.
Loading

1st Prize - Apple iPad


SQLServer Quiz 2011 - How do you track your variable values in SSIS?

  • Describe the steps required to enable auditing of variable value changes in an SSIS package to a table in a SQL Server database?

    Posted on 06-20-2011 00:00 |
    Rushabh Mehta
    1033 · 0% · 25

4  Answers  

Subscribe to Notifications
  • Score
    8

    1.Set the "EvaluateasExpression" property of the variable as True.

    2.Set the "RaiseChangedEvent" property of the variable as True.

    3.Create an event handler for the "OnVariableValueChanged" event for the container in which the variable is scoped.

    4.Add an execute sql task in event handler to insert the current value of the varibale in a table by writing the Insert statement and passing the variable as parameter.

    Replied on Jun 20 2011 8:47AM  . 
    Nitesh Rai
    138 · 1% · 361
  • Score
    1

    Create copy of variable. OnvariableValueChanged event on PAckage.

    Replied on Jul 6 2011 7:06AM  . 
    Alpesh Patel
    36 · 5% · 1663
  • Score
    1

    OnVariableValueChanged Event On Package and maintain some log file for tracking those values in it.

    Replied on Jul 6 2011 11:47PM  . 
    Manoj Bhadiyadra
    147 · 1% · 335
  • Score

    I have a blog post to show how I logged variable values to the default logging table [dbo].[sysssislog]. The log is created "when the variable value changes". https://aalamrangi.wordpress.com/2014/12/11/how-to-log-ssis-variable-values-during-execution-in-the-event-log/

    My example uses the OnVariableValueChanged event (and its scoped variable [System::VariableValue]) to run an Execute SQL Task that writes values to the table. Of course, the Execute SQL Task can be easily modified to log the variable values to your own custom table.

    Replied on Jan 6 2015 10:01AM  . 
    aalamrangi
    2401 · 0% · 5

Your Answer


Sign Up or Login to post an answer.
Please note that your answer will not be considered as part of the contest because the competition is over. You can still post an answer to share your knowledge with the community.

Copyright © Rivera Informatic Private Ltd.