Hi All, I Have created SQL Server configurations for Dev source and destination files. I wanted to use the same configuration to my Prd environment but able to dynamically change the destination to Production server while executing the package. Is it posible? also I dont understand how the environment varibale and SQL server configurations are related. Could anyone help me? Thanks

Hey Thanks Deepak, I have asilly question, I understand the EV must be avilable before I create indirect method config, so what sould be the EV values at the time I create the EV? Thanks,

Thanks for the links Jason, But still some gray are out there, Please see below my scenario I have 3 packages I have used 3 variables on package1 are , flatfile source1, flat file source2, dev SQL Destination Then I have reused the config to other 2 packages. Again the source files are not same for all 3 packages. pk1- flatfile1 source pk2-flatfile2 source pk3- Dev SQL source and the destinations are Dev SQL for all 3 packages. If I wanted to deply this 3 packages to Prd SQL Destination at run time , what is the best way to do so? I could do by creating different config files for Dev & Prd, but I wanted to use the same config file but chnage the destination during deployment or package execution. Thanks in Advance,

Thanks Jason, it's really helpfull, Do I need to create the same varibales on all 3 packages? Thanks,

Yes you are, just to make sure, I am going to create all the 3 variables in all the 3 packages whether they are used or not within the package, am I right?

Hi Jason, I have successfully deployed the dev config also it worked, but when I changed the config with prd server details its giving warnings, Verufy the package path, Package path can't be found failure importing config file :C:\..........\xxxx.config Any thoughts??

Thanks Jason, It was very helpful, one more thing, I created dev server connection string withing package, and changing the prd server details on the config file. Do i need to have prd connection string also to be created with package be fore deploy the package?? Thanks,

experiancing new issue, I have saved the connections strings to 3 different variables on pk1 then reuse the varibales within pk2 & pk 3 I just closed BIDS and open, there are no values for the variables, what ever i saved all missing. any idea??? Thanks,

How? Coz I created the Var assign the values, saved the var to connection manager expressions, am I missing some thing?

Hi Jason, Thanks alot, but I have done exactly the same.

Ohh man, Im tired, Now i could see all the variables and values in the config file, but when I execute the package in Execute package utility, execute succesfully, there are no errors, but I dont see any data in the destination tables. Sorry to bother you Jason.

Hey Jason, No worries, it was my bad, I have change the dest table, and was checking at the wrong table. It seems working fine, My mistake was, kept the config file in the default path, which was not same as on dev environment. Great stuff, Thanks alot Jason, appreciate your help.

Thanks Jason, few more clarifications. see my connections on a single config file <Configuration ConfiguredType="Property" Path="\Package.Variables[User::DevSqlDest].Properties[Value]" ValueType="String"> <ConfiguredValue>Data Source=DevServer;Initial Catalog=db;Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=SSIS-PMI_PPN_Import-{3C58E004-4460-4927-A4DE-BA00D35F3B1D}Devserver.db;</ConfiguredValue></Configuration> <Configuration ConfiguredType="Property" Path="\Package.Variables[User::PMI_DataSource].Properties[Value]" ValueType="String"> <ConfiguredValue>Flatfile.csv</ConfiguredValue></Configuration> <Configuration ConfiguredType="Property" Path="\Package.Variables[User::PPN_Datasource].Properties[Value]" ValueType="String"> <ConfiguredValue>Flatfile.csv</ConfiguredValue></Configuration></DTSConfiguration> Q1- Why the aaplication name populated on the destination config (1st one)? Q2- If I can resuse the config between the packages why should I recreate the variables again? Also I have to set the values for the varibales, seems double work. I genarated the above config file, them copied the development folder to production server and chnage the server name to Prd server and run the manifest file. Still complaines could not find the variables. Thanks, Thanks,