Post reply

Package Configuration quandary

  • August 13, 2013 at 5:28 pm

    #281852

    I have an SSIS Solution with a dozen packages in which I am using a Package Configuration (XML file with an Environment variable) to store several of my DB connections. I did this to allow me to move from DEV to PROD without having to modify connections in the package. Now I am developing another package under the same solution with a brand new DB connection that will not be used in any of the existing packages. When I add this new connection to the existing Package Configuration XML file the existing packages were not happy because 'the specific connection element is not found'. I was trying to make my Configuration file rather generic so that moving between DEV and PROD would be painless and I could use the file within lots of different solutions regardless of which DB connections were being specified. It seems rather inefficient to add unused connections to each package just to satisfy the Package Configuration file. Is there a way to 'over construct' a Configuration file so that a package does not throw an error when unused elements are not found? Or am approaching Package Configs in a dreadful manner?

    Thanks

  • August 14, 2013 at 3:41 am

    #1641275

    This is the reason why I prefer SQL Server config tables over XML files.

    In a table, you have a configuration filter. With this filter, you can group configurations together.

    In your case, you would just have to add a new configuration to the table, specify another filter and you're done.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • August 14, 2013 at 5:16 am

    #1641321

    Any suggested readings regarding the implementation of SQL Server config tables?

    Thanks

  • August 14, 2013 at 5:31 am

    #1641325

    Farm Boy (8/14/2013)

    Any suggested readings regarding the implementation of SQL Server config tables?

    Thanks

    This one sums it up quite nicely:

    31 DAYS OF SSIS – SQL SERVER CONFIGURATION [/url]

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply