Re: Global variables disappears after package run
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 08/10/04
- Next message: Allan Mitchell: "Re: Conversion error"
- Previous message: Ed: "Fire a DTS in a stored Procedure..."
- In reply to: Alexander Sinitsin: "Re: Global variables disappears after package run"
- Messages sorted by: [ date ] [ thread ]
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 > >
- Next message: Allan Mitchell: "Re: Conversion error"
- Previous message: Ed: "Fire a DTS in a stored Procedure..."
- In reply to: Alexander Sinitsin: "Re: Global variables disappears after package run"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|