SSIS Indirect Configuration
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
April 26th, 2011 5:48pm

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,
Free Windows Admin Tool Kit Click here and download it now
May 3rd, 2011 2:58pm

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,
May 3rd, 2011 3:10pm

Thanks Jason, it's really helpfull, Do I need to create the same varibales on all 3 packages? Thanks,
Free Windows Admin Tool Kit Click here and download it now
May 3rd, 2011 4:51pm

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?
May 3rd, 2011 5:18pm

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??
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2011 7:51am

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,
May 4th, 2011 8:39am

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,
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2011 9:50am

How? Coz I created the Var assign the values, saved the var to connection manager expressions, am I missing some thing?
May 4th, 2011 9:59am

Hi Jason, Thanks alot, but I have done exactly the same.
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2011 10:24am

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.
May 4th, 2011 10:47am

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.
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2011 11:17am

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,
May 4th, 2011 11:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics