hii Am having like 10 packages with same Sql Db destination.i wanna use environmental variable as configuration . Am putting the connection string in envi variable and want to use that for all 10 packages but the pro is package name is also coming in connection string like Data Source=XXX-devdw;Initial Catalog=Staging;Provider=SQLNCLI10.1;Integrated Security=SSPI;Application Name=SSIS-I-034-{CEA19D19-E609-4103-BC84-7342980493D2}XXX-devdw.Staging; How can i eleminate (Name Application Name=SSIS-SamplePackage-{CEA19D19-E609-4103-BC84-7342980493D2}XXX-devdw.Staging;) in the connection string?? i just want servername ,dbname and integrated security as am putting in envi variable.??

Hi, You can create an envirnoment variable and store the connection string value along with password and configure package configarations in your Package .As per your Problem, of application name in your connection string in ssis package its temporary . At runtime if you have configured your package connection string will be taken from envirnoment variable. Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/