Hi, Could anyone please tell me the logic behind and the steps for deploying SSIS packages using environmental variable? How is it better than the File system or SQL server deployment? why should we go for this? Thanks in advance!

The Env variable just tells where to find the config. This way a package becomes very portable See the following post for more info: http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/ PS: Make your post an issue.Arthur My Blog

using environment variable with xml config or sql server config will generate an INDIRECT CONFIGURATION actually address of xml config or connection of sql server config will be stored in the environment variables, so when you deploy the package, if you want to change xml config file path or sql server config connection string, simply you can change the environment variable's value.http://www.rad.pasfu.com

Hi, Could anyone please tell me the logic behind and the steps for deploying SSIS packages using environmental variable? How is it better than the File system or SQL server deployment? why should we go for this? Thanks in advance! I think there is no way SSIS packages can be deployed using environment variables.They are a means to store few of the properties in SSIS packages like connections , configurations , file paths and the package path itself can be stored in env variable. This is indirect configuration as Reza said.Check this for more information : http://msdn.microsoft.com/en-us/library/cc671625.aspxHappy to help! Thanks. Regards and good Wishes, Deepak. http://deepaksqlmsbusinessintelligence.blogspot.com/