Groups | Blog | Home
all groups > sql server dts > july 2006 >

sql server dts : SSIS: system variables with same name & scope?



jcorning NO[at]SPAM gmail.com
7/28/2006 2:36:14 PM
Hi all -

Running into a problem with SSIS and a google search doesn't yield much
help.

I have a package with multiple tasks and about 10 OnError event
handlers defined (one for each task). I need to go in and change the
System::Propogate variable for some of the event handlers to make sure
that if they fire an Error, it does not propogate up to the package.

The problem is this - I can't match up the system variables to the
actual task event handler in question.

My Variables window shows 10 variables with Name = "Propogate" and
Scope = "OnError" -- even a check of the properties page shows that the
only difference between them is the GUID. There seems to be no way to
match the variable to which task event handler it is scoped to.

No additional columns to add to the Variables window that are relevant,
and even drilling down into the actual event handler, I still see all
of the System variables.

Has anyone encountered this and/or found a workaround?

Thanks,
Jamie
Allan Mitchell
7/29/2006 12:00:00 AM
Hello jcorning@gmail.com,


Try adding your own namespace to the variable. In the variables window hit
the button that says "Choose Variable Columns" and choose namespace


Allan

[quoted text, click to view]

AddThis Social Bookmark Button