SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

chbala85
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

Thanks..........

bandi
Flowing Fount of Yak Knowledge

India
2210 Posts

Posted - 06/06/2013 :  03:40:48  Show Profile  Reply with Quote
http://stackoverflow.com/questions/11219441/ssis-package-configuration-environment-variable


--
Chandu
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 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

http://sqlscape.wordpress.com/tag/direct-vs-indirect-configuration/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Rasta Pickles
Posting Yak Master

United Kingdom
171 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  
 New 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.09 seconds. Powered By: Snitz Forums 2000