SSIS 2012 Environment variables are not on sort order

• mhafiez

  Old Hand

  Points: 369

  More actions

  February 10, 2014 at 9:51 am

  #303956

  Hello,

  I've battling this issue for a while, I have SSIS 2012 Enterprise, using catalog deployment and have more that 50 environment variables for connection to databases across my enterprise.

  the problem when i go to configure the packages after deployment and pick the proper env variables, that are not sorted, so i have to browse all entries in order to find the proper entry in environment variables.

  did anybody encounter this issue before?

• SumLasty

  SSCommitted

  Points: 1923

  More actions

  February 27, 2014 at 12:00 pm

  #1692829

  You could query SSISDB to get metadata/configuration details in 2012.

  This query would help

  select ie.environment_id, ie.environment_name,

  iev.name, iev.value

  from internal.environments ie

  JOIN internal.environment_variables iev ON ie.environment_id = iev.environment_id