SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 package configurations
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sravanim
Starting Member

37 Posts

Posted - 06/19/2012 :  07:19:58  Show Profile  Reply with Quote
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

India
48061 Posts

Posted - 06/19/2012 :  14:21:56  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000