Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 package configurations

Author  Topic 

sravanim
Yak Posting Veteran

58 Posts

Posted - 2012-06-19 : 07:19:58
why we have to use package configurations when we are creating a SSIS package?package configurations are mandatory or not?what is package coniguration?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-19 : 14:21:56
package configurations are way of making package dynamic. This comes handy when you migrate package across environments ie from dev to qa to prod. The ackage configurations gives you place holders through which you can control package properties from outside without keeping the need for editing the package. its not mandatory but always nice to have to add flexibility and in most cases you require it as environment where it finally executes is different from enviroment where you develop.

more details here

http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -