May 20, 2011 at 2:22 pm
I inherited approximately 150 SSIS packages doing various ETL operations. They use a custom table that requires that we add a new column when a new package requires a new type of config data storage.
As part of an upgrade and partial rewrite effort I am exploring, among other changes, switching to SQL Server Package Configurations to manage configuration data. What do you think of the following?
1) Having two Package Configurations per SSIS package. Both will be pointed to the same database containing only the config table, but with different filters. One filter will be specific to the package that will contain package-specific configuration data and one will be called "global" which will contain configuration data that all packages share (things like "default alert email" should Armageddon ensue during package execution).
2) How best to manage configuration data when moving a brand new package from DEV to STAGING to PRODUCTION?
3) How best to manage properties for the connection object used to initially connect to the Package Configuration database/table?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 22, 2011 at 11:46 pm
Regarding poins 2 and 3, see my answer in this thread:
http://www.sqlservercentral.com/Forums/Topic999328-148-1.aspx
Point 1: I don't see an issue with that at first sight. I use it myself from time to time.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 23, 2011 at 9:54 am
Koen Verbeeck (5/22/2011)
Regarding poins 2 and 3, see my answer in this thread:http://www.sqlservercentral.com/Forums/Topic999328-148-1.aspx
Point 1: I don't see an issue with that at first sight. I use it myself from time to time.
Regarding Point 1: thanks for the sanity check.
Regarding Point 2 & 3: I carried on in the other thread.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply