ssis package configuration table

• mesql-895214

  SSChasing Mays

  Points: 643

  More actions

  May 12, 2009 at 8:31 pm

  #131335

  I have a master child package and using ssis sql server configuration table. In the development environments the package was using a server called ‘DEV01’ to pull up data (dev01 is the exact copy of my production). Now we moving to production my manager wants me to get the data from another server called ‘prodrp’. My question is how do I update the sql configuration tables.

  In my master-child package I have 8 packages. 2 of these(initial and requiredload) packages uses ‘DEV01’ as the source.

  Am think it would be something like this

  Update ssisconfig_table

  Set ConfiguredValue = replace (ConfiguredValue, ‘DEV01’ ,‘prodrp’)

  Where ConfigurationFilter in (‘initial’ ,‘required load’) and

  ConfiguredValue like ‘%DEV01%’

  Or do I only need to update the connection string for the master package like this

  Update ssisconfig_table

  Set ConfiguredValue = replace (ConfiguredValue, ‘DEV01’ ,‘prodrp’)

  Where ConfigurationFilter = ‘master’