July 29, 2009 at 12:58 pm
I have user variables in a package. I am trying to set up package configuration under SSIS menu in BIDS. I am using SQL Server table [SSIS Configurations]. I am interested in user variables in the package, but 'Select properties Export' shows Data Flow Task and a folder under it called 'Varliables', but there is no tree with variables in it. How can I get variables to show here?
I want to give the user the ability to change the user varibale values in the [SSIS Configurations] table; user can run a job that uses the package which in turn uses the values in this table for user variables.
Note: In BIDS under Package Explorer tab, Tree shows Executables, Data FLow task, Variables - I can see the varibles here. I have SQL Server 2005 STD Version, I hope this version allows this capability. Any help is appreciated.
July 29, 2009 at 1:08 pm
I think you are discussing Variable Scope. A variable can be created at the package level and at basically any sub-level. A package configuration can manipulate package variables at any level, I don't believe that edition matters in this regard. I tend to declare my variables at the package level.
CEWII
July 29, 2009 at 3:01 pm
Thank You. I recreated the variables in the DataFlowTask pane, it defaulted to scope 'Data Flow Task', which matched to what is shown under 'Package Explorer' pane. It worked.
Initially when I posted the problem it defaulted scope to the name of the solution/package (not "package"), I could not change it to scope "package", so I recreated as indicated above after seeing your response. Thank you again that helped.
July 31, 2009 at 8:45 am
You are very welcome, most of these questions I see are directly related to variable scope. I'm glad I could help.
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply