Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Andy Leonard SSIS Properties RE: SSIS Properties

  • February 7, 2011 at 9:13 am

    #1283200

    gmby (2/7/2011)

    I cannot seem to find any examples. I wonder if we are the only ones using config files in this fashion?

    I use them like this for every SSIS package in production becuase of JSOX and Change Control polices.

    We have multiple test environments on one SQL instance (2005), so we use the /CONFIG switch to point to different XML package configurations at runtime.

    Am going to test using tables for package configs with the /CON to change values at runtime. If that works and we cannot find the proper syntax, it might be the quickest refactoring effort for us to upgrade to 2008R2.

    This is exactly why we are not using 2008 in production yet. Our JSOX and Change Control policy does not allow for re-writing or updating the package file when moving from Uat to Prod. We can update the configuration. Since the database and server names are differant in Prod and are set at design time this makes it a lot of fun.:hehe:

    I hope you find an answer. It would be nice to be able to start migrating/using SSIS on SQL 2008. This six year old VS2005 IDE is getting on my nerves 😛