2Tall (3/31/2015)
Phil one last question. If individual environment variables are created for Server Name / User / Password the subsequent SQL Agent Job appears to be only able to reference a single environment.Any ideas on how can I use multiple variables and then schedule to run as a job?
Thanks,
Phil.
A single environment can contain many variables.
Projects can include references to multiple environments (not recommended, but could be one for QA and one for Prod, for example), but when you run a package, you can specify only one of these.
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.