loop over all variables to change an variable property

Question

I'm currently working on an package template for my developers.

I have build an OnValueChanged - EventHandler.  ( i use the great example from Eric Wishdal: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/a1987e67-37d1-4998-a978-9930d029455c)

But now i want to get shure that all variables in the package have the property: RaiseChangedEvent = True

I currently hang on an loop over all variables in the package.

Because i want to build this in an template i didn't know what variables the developers use in the future.

Does anyone have an example for such an loop?

greetings

selcer

Answer 1

Looping where?

And why each variable necessarily has to have the OnValueChanged event fired?

---

Arthur My Blog

Answer 2

As i say i want to create a template for package logging.

If a package crash i want to know the last values of the variables, such as the value of the variable that hold the last value for an dynamic set import file. Because i build an template i search for an robust solution completly implemented in eventhandlers.

We don't have a big set of rules here for package building. We have only one: Use this template for logging.

Answer 3

As i say i want to create a template for package logging.

If a package crash i want to know the last values of the variables, such as the value of the variable that hold the last value for an dynamic set import file.

I think you can make custom log table. The value of that variable can be loaded into log table.

Thanks,

---

hsbal

Answer 4

You wuold be able to capture the variable values on failure of a package using a checkpoint.  The easiest way to iterate through all variables in a package would be within a script task using the Dts.VariablesDispenser.  There is documentation on this on MSDN here:

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.variabledispenser.getvariables.aspx?cs-save-lang=1&cs-lang=csharp#code-snippet-1

Look at the code snippet using foreach to iterate through and replace the code to set the variable value.

Also take a look at Checkpoints here.  You could create a template that configures using an SSIS Checkpoint that would record variable values on failure.

http://msdn.microsoft.com/en-us/library/ms140226.aspx

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.variabledispenser.getvariables.aspx?cs-save-lang=1&cs-lang=csharp#code-snippet-1

---

David Dye My Blog

Answer 5

Note: It's not possible to loop through all variables without selecting them all as readwrite or readonly variables in The Script Task editor...

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 6

Note: It's not possible to loop through all variables without selecting them all as readwrite or readonly variables in The Script Task editor...

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

it didn't solve my problem. But i found that there is no need to add variables to the ScriptTask Dialog for usage in the Script Task.

A blog over this feature is here: http://josef-richberg.squarespace.com/journal/2009/8/12/using-variables-in-ssis-script-component.html

Answer 7

Note: It's not possible to loop through all variables without selecting them all as readwrite or readonly variables in The Script Task editor...

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

it didn't solve my problem. But i found that there is no need to add variables to the ScriptTask Dialog for usage in the Script Task.

A blog over this feature is here: http://josef-richberg.squarespace.com/journal/2009/8/12/using-variables-in-ssis-script-component.html

So now you still have to lock them for write or read by naming them all...
http://microsoft-ssis.blogspot.com/2010/12/how-to-use-variables-in-script-task.html

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter