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.
| Author |
Topic |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-01-29 : 06:22:32
|
| Hi,I was planning to create a package configuration using Configuration type - SQL Server.Please correct me if i'm wrong in the approach i did.1. Create an environment variable to hold the connectionstring of the Config table.2. Create a SQL Server configuration to store the config info in the table with ConfigurationFilter in order to store multiple package config info.3. In the Mycomputer's Properties -> Advanced->Environment variables -> Add variable and its in the form of "ServerName.DBNAME";"[DBO].[SSIS CONFIG]";"ConfigurationFilter";Once done, I tried to deploy the packages to the target system which is different from the development environment.Before proceeding, i copied the content from the config table with data into the target system and changed all the relevant info. in the table.After this, 1. Should i need to create an environment variable of the same name which is created earlier in the target system and since it holds multiple config info in the same table based on the config filter, Should i need to create multiple environment variable in the target system???What i felt is, XML config file is quite easy and portal as compared to the above method and also bundled with the deployment utility.Your suggestion is highly appreciated. |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-02-02 : 07:14:42
|
| Any help on this... |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Package configuration - SQL Server