Hi, I need to configure my package using SSIS Configurations. When I opened SSIS Configuration wizard, press ADD and selected Xml Configuration, I found two options. One being : Specify configurations directly. next : config location is stored in env variable. How to use the second option?[ env variable]. Say I want to configure my connection string for my destination database [ OLEDB Destination Component]. How to do that using second option. Thanks Kishan

You first need to create your configuration file so go for option 1. Once you've created it, create an environment variable whose value is the path and filename of the config file. Go back into your configuration and edit it to use the environment variable rather than the config file. And that's it! In case it helps: SSIS: Indirect configurations ROCK! -Jamie

this link might also help: http://dotnetjunkies.com/WebLog/appeng/archive/2006/05/30/indirectconfigpackagessis.aspx

Jamie, Could you please clarify my doubt..? Direct configuration: it points to a file which having some path. (XML, SQL Server) Indirect configuration: it stores values and properties in environment variable. (environment variable, parent package, Registry) Am I right..? Please correct me if Iam wrong.. Thanks.. Desarado..

You first need to create your configuration file so go for option 1. Once you've created it, create an environment variable whose value is the path and filename of the config file. Go back into your configuration and edit it to use the environment variable rather than the config file. And that's it! In case it helps: SSIS: Indirect configurations ROCK! -Jamie Jamie, Could you please clarify my doubt..? Direct configuration: it points to a file which having some path. (XML, SQL Server) Indirect configuration: it stores values and properties in environment variable. (environment variable, parent package, Registry) Am I right..? Please correct me if Iam wrong.. Thanks.. Desarado..

Hi Jamie, Could you please let me know how can I use the Environment variable with SQL Server Config table? Many Thanks,

Desparado, yes you are right with respect to indirect configurations in SSIS. Also to add, the XML configuration file path can be used in the environment varaible. Swordfish, As per my knowledge, environemnt varaibles can refer to windows paths and could not refer to any sql tables. But here is one approach : 1) Use the configuration file location in environemnt varaible. 2) In the package , the SQL server configuration connectoin can be created(where the configuration will be stored in a table). 3) The connection created in step 2 will be configured again by the configruation file of the pcakge. 4) So, the sql server configuration connection is stored in a XML configuration file whose location is in turn stored in an environemnt varaible. Thus a relationship established between SQL config and environment varaible. Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.

Hi Jamie, Could you please let me know how can I use the Environment variable with SQL Server Config table? Many Thanks,

What would be EV value if my configs saved to SQL table? Thanks,

What would be EV value if my configs saved to SQL table? Thanks,