January 15, 2014 at 1:51 am
I am about to deploy my package on a file system of a server ie as xml. I will be creating a package config file for this. I am already using config files for my DB connections. When I make my package config file, will the info from DB connection config files be copied into it ? If not, then why ?
January 15, 2014 at 3:11 am
I am not sure what you mean by your question.
Package configurations can be used to configure connection strings for the Connection Managers contained within your packages and those package configurations can be either direct (e.g. an XML file) or indirect (e.g. a SQL Server configuration that refers to a database and table containing the connection strings).
How are your currently configuring your connection strings? In terms of overwriting, if you have package configuratons and they are enabled, they will overwrite any design time values that you have specified for your Connection Managers.
Does that answer your question?
I am assuming your are using SQL Server 2005/2008R2 as in 2012, package configurations have been replaced by Environments, Environment Variables and Parameters
Regards
Lempster
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply