Re: Global variables disappears after package run

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 08/10/04


Date: Tue, 10 Aug 2004 20:27:35 +0100

Never seen this.

You have variables declared in a package at design time, You run the package
(How?) and they disappear?
What is the declaration of the variables (Datatype etc) not that this should
make any difference?
What SP are you running?

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Alexander Sinitsin" <al_sin[dog]ukr.net> wrote in message
news:e1pWudtfEHA.704@TK2MSFTNGP09.phx.gbl...
> Hello, Allan!
> You wrote  on Sat, 7 Aug 2004 09:25:43 +0100:
>
>  AM> Not sure what you mean here
>
> After succesfully execution of package, all variables disappear. Even if
> package was saved with these variables.
> For example, var A always present in the package, var B added dinamically.
> After package execution GV list empty.
> My package save result of some tasks in global variables. If we start
> package task-by-task manually, we can see this vars. But when we run
entire
> package, we don't see any variables.
>
>
>  AM> If you are saying GV values are not persisted from your Execution of
>  AM> the package to when you reopen the package then that's true.
> Yes, I know. Only issue - existed variables disappear too.
>
>  AM> The only way to do this would be to SAVE the package back again.
>  AM> likewise with anything you add to the package at runtime then if you
>  AM> do not save it back then it exists for the lifetime of that run
>  AM> only.
>
>  AM> -- 
>  AM> -- 
>
>  AM> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>  AM> www.SQLDTS.com - The site for all your DTS needs.
>  AM> www.konesans.com - Consultancy from the people who know
>
>
>  AM> "Alexander Sinitsin" <al_sin[dog]ukr.net> wrote in message
>  AM> news:uFi0XuveEHA.3476@tk2msftngp13.phx.gbl...
>  >> Hello, All!
>
>  >> I can take these steps:
>
>  >> 1. Load package. Global variables contains some vars.
>  >> 2. Run package. At run time new variables added by custom task.
>  >> 3. Package completed. Global variables list EMPTY. There is no any
>  >> variable - not existed at point 1, not added at point 2.
>
>  >> After last step I make dump of all GV to disk - GV are OK. So,
>  >> variables exists at runtime.
>
>  >> My custom task doesn't contain code to drop variable. Only new
>  >> variables added.
>
>  >> I can't find description about GV scopes. Is there some issues?
>
>  >> With best regards, Alexander Sinitsin.  E-mail: al_sin[dog]ukr.net
>
>
>
>
> With best regards, Alexander Sinitsin.  E-mail: al_sin[dog]ukr.net
>
>


Relevant Pages

  • Re: update messages
    ... there's no chance that a package is going to ... disappear from your box unless you deliberately remove it, ... you when you attempt to upgrade, and you won't give them permission to ... Why didn't you notice *before* the dist-upgrade? ...
    (Debian-User)
  • Re: update messages
    ... there's no chance that a package is going to ... disappear from your box unless you deliberately remove it, ... Why didn't you notice *before* the dist-upgrade? ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: Sunday and its still snowing...
    ... >> Doesn't it just 'disappear' if you put it in the bath? ... Package it up and send it to China where they need the water. ... Prev by Date: ...
    (rec.travel.europe)
  • Install Component Package
    ... I'm installing a package. ... I exit and reenter, the package ... was disappear. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Why use custom component for class?
    ... > that you use the New Package tab and create a package for your own ... > difficult to manage at design time than descending directly from the edit. ... Someday when I have more time I'll try the regular component-creation (as ... descendant) thing yet again and yelp for group help when Delphi does its ...
    (alt.comp.lang.borland-delphi)