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
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply