Hi All, I am trying to set connection string for an SSAS database from command line. I set the property of connection string to accept it from a expression using a variable. But when I execute this package from command line, its only taking the value which is hard coded and not the one which is being passed to it dynamically. Can anyone suggest if I am doing something wrong? Thanks Ayush

Hi, For expose this property you should configure 'Package configurations' on SSIS menu on BIDS. From here you can select the variables and other properties from components and package. Check http://msdn.microsoft.com/en-us/library/ms141682.aspxVctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

Thanks For the reply Victor. I have two scenarios, where I need to run a package 1. From a command file 2. Calling from a parent package variable. If I run from command file I can use the configuration probably. But from parent package I am not sure if I can use package configuration, because I need to use the same SSAS Server connection which the parent package used. Can you please suggest some thing? Thanks Ayush

Hi Ayush, We can pass variable from parent package to child package too. Below is the article details this topic: http://msdn.microsoft.com/en-us/library/ms345179.aspx Please feel free to ask if there is anything unclear. Thanks, Jin ChenJin Chen - MSFT