September 25, 2014 at 6:05 pm
Does anyone know if there is a fix for the seemingly random sort order of the variables in the dropdown list when configuring parameters and connection managers in the SSISDB catalog?
I imported all of our connection strings into an environment (about 200 of them). They were inserted in alpha order and the ID values within the internal.environment_variables table shows them in order as well, by ID and by name.
When I run profiler and capture the command that retrieves them and run it in ssms they are in order but in the dropdown they seem random.
There are no values within any of the tables that accounts for the order they are in. :crazy:
If a package has 5 connections you need to go through the unsorted list 5 times to find them.
Sometimes you get lucky and they are in the first 20 or so. :w00t:
I know I can write a script, just wondering if there is a fix for the sorting.
May 14, 2015 at 4:08 pm
I see the same problem - I have about 100 environment variables that I need to assign to about 20 packages (and the project as well). This would be a straightforward exercise if the list was sorted but because it's not the process becomes quite a bit longer to accomplish.
May 14, 2015 at 4:11 pm
I feel your pain brother!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply