What is the uses of Environment variable explain give me some example.

Question

What is the uses of Environment variable explain give me some example.

chbala85

Newbie

Points: 3
More actions
June 4, 2013 at 12:23 am

#274596

Hi ,
i am new to ssis ,but in my package used Environment variable .Plaese explain give me with some example.
Thanks,
bal85

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

olaf.dedig SSC Enthusiast Points: 126 More actions · Answer 1

Enviroment Variables have a bunch of uses some of the most common one are the location of a file to import as this usually differs from Dev / test and live enviroments the path / email etc can be set at time of deployement to that enviroment.

There are many other uses, this is just the most common one I have found.

hope it helps.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

I used environment variables to set the connection string to my SSIS configuration database in my different environments (dev/qa/uat/prod). This is the most common type of use.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question