Order that Package Configurations are read?

• keymoo

  SSCrazy

  Points: 2975

  More actions

  August 22, 2008 at 7:52 am

  #154649

  Hi there,

  I'm trying to deploy a package to a different network (production environment) and am coming up against some issues. I have developed my package in the dev environment and have used Package Configurations to make the package dynamic. See screenshot of my Package Configurations Organizer:

  

  I have one Package Configuration that points to an XML file which tells the SSIS package where to get configuration information from. The rest of the Package Configurations are stored in SQL Server in [SSIS Configurations].

  What I want to happen is when the package starts, to go to the XML file to find out where to get the rest of the configurations from (i.e. they're all in SQL Server in [SSIS Configurations]0. It all works fine in DEV, because I suspect that SSIS is NOT using the package configurations I have set up, but is using the hard coded values. I don't understand why SSIS is not loading the Package Configurations from the XML file and [SSIS Configurations].

  I'm wondering if SSIS is trying to evaluate the SQL Server SSIS Configurations before it knows where to go to get them.

  Thanks!!

• keymoo

  SSCrazy

  Points: 2975

  More actions

  August 22, 2008 at 9:41 am

  #861998

  Hi, I solved it using an Environment Variable as described in this article http://www.mssqltips.com/tip.asp?tip=1405

  Thanks for looking.