Re: DTS SQL 2000 Global Variable initialization problem - please h

What I was trying to say is that globals to persist. That's how they work.
Many people put "settings" in them at design time that control execution.
It's by design.

Furthermore, when I suggested putting an "init" script in the package to set
them, and that you'd "clear some" and "set some", I meant entirely at YOUR
decision, you'd either "clear" some or "set" some, oftentimes through a
config file.

If you don't want a variable to persist, the solution is remarkably
simple... clear it in the "init" script!

"jason.essebag@xxxxxxxxx" wrote:

On Oct 11, 9:21 am, Todd Beaulieu
<ToddBeaul...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Can't you just add an "init" script as the entry point and have it clear
out/set any globals to what you want them to be for the run? I'd say you
should do this as a matter on convention in every package. Some variables
will be cleared, others will be set from config files, database lookups, etc.



"jason.esse...@xxxxxxxxx" wrote:
Hi, I have an issue with myDTSand I need somehelp.

Myglobalvariables seem to keep the same value since the last
execution.

This is aproblemfor me because I need to rename a part of the file,
so the part that is not changed from the original still remains in the
new name.

Example

FILEABC_12345 gets processed through myDTSas PROCESSED_12345. If I
place a new file in the directory called FILEABC_6789 then my
processed file for that one now becomes PROCESSED_12345 since the
globalvariablekept that value of the original example.

How can I resetGlobalVariables every run? I am using
DTSGlobalVariables.Parent

Help!

jason.esse...@xxxxxxxxxx Hide quoted text -

- Show quoted text -

Hi Todd,

I have an activeX script that sets it to empty string, and have it as
output in a msgbox to ensure it's the case before and after its use.

For some reason the global variable is persistent. I'd like to save
config files as a last resort, I am surprised DTS is designed to
behave this way.

Some variables will be cleared

Which variables will be cleared?


.

Relevant Pages

  • Re: defvar affecting captured closure variables ?
    ... but global specials used to be the DEFAULT ... those of us on the CLTL design team basically said something very close ... the *foo* naming convention was not widely used in most ... bind these globals, since otherwise you'll get a lexical foo when you ...
    (comp.lang.lisp)
  • Re: DTS SQL 2000 Global Variable initialization problem - please h
    ... Many people put "settings" in them at design time that control execution. ... when I suggested putting an "init" script in the package to set ... will be cleared, others will be set from config files, database lookups, etc. ... Do you have an example of an init script I can use for initializing ...
    (microsoft.public.sqlserver.dts)
  • Re: WSAStartup, WSADATA, and class hierarchy
    ... >>> class Winsock ... > Then call it from ctor of each of your globals. ... configured for public availability via .conf files, ... It's possible my design is flawed, I'll admit, but I think that ...
    (microsoft.public.vc.language)
  • Re: Singleton Pattern
    ... that uses the singleton pattern to create just about everything. ... When you skip globals and start to pass variables ... you alter your design so that you don't have to do that as ... you discover that not everything needs the database and your design ...
    (comp.object)
  • Re: Object is not Valid Error
    ... getting from referance from create.vi.I verified referance getting from ... doing a Read or write on that object reference from another VI. ... about globals for this purpose altogether. ... a design before starting to actually code according to that design ...
    (comp.lang.labview)