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.

SQL Server BI Quiz 2011 - Home

Loading

1st Prize - Apple iPad

Recent Posts

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
    1010 · 0% · 25

3  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
    135 · 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
    153 · 1% · 315

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.