Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 Environment Variables in ssis
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

49 Posts

Posted - 06/06/2013 :  03:22:31  Show Profile  Reply with Quote
what is uses of Environment variable in ssis congigaration .Give some example with step by step in ssis.

please help me


Flowing Fount of Yak Knowledge

2242 Posts

Posted - 06/06/2013 :  03:40:48  Show Profile  Reply with Quote

Go to Top of Page

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 06/06/2013 :  04:10:04  Show Profile  Reply with Quote
One of common scenarios where we've used environment variables is when we want to use indirect configuration for packages.
The package will have lots of configuration items (Connection managers, variables etc) which will make use of a XML configuration file to store values. But this still has issue of file path being static which would require XML config file to be present in same path as in local machine when you deploy package to server.
To deal with this, what we do is to store the XML file path in environment variable and then in configuration properties map the variable to indicate this. The various environment servers(dev,qa,prod) will have environment variable present with correct path value for the XML config file.

same is documented here

SQL Server MVP
Go to Top of Page

Rasta Pickles
Posting Yak Master

United Kingdom
174 Posts

Posted - 06/08/2013 :  13:29:03  Show Profile  Reply with Quote
To add to previous posts, environment variables can help you to overcome such superb Microsoft error messages as:

You cannot perform operation Remove on an object in state Existing. (Microsoft.SqlServer.Smo)

Yes, I've copied and pasted that error message from SSMS 2008R2.

I kid you not.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000