February 2, 2009 at 5:46 pm
Hello folks,
I am building ETL, or rather ELT process. I have multiple packages which run once a day. Currently every package has the same variable ExtractTime which is used to determine extraction time. The variable is exactly the same across all packages and it becomes harder and harder to maintain as I am not sure what I might've had modified.
Is there a way to define a truly global variable with the scope spawning across multiple packages? Maybe global to a solution?
Thank a lot for your help in advance!
Pit.
February 2, 2009 at 7:06 pm
Not really. You might consider creating a physical 'Variables' table in SQL Server and using that to store/lookup any variables which are truly global.
Phil
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
February 2, 2009 at 7:10 pm
Thanks a lot for reply.
Creating a table for global variables was my last resort. 🙂
February 2, 2009 at 7:17 pm
For one solitary piece of data it's certainly a pain - but if you are generic about how you write it you will be able to reuse in future.
Phil
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply