This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 21%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
I have added an additional Environment to my project deployed in the SSIS Catalog. However the ADF Designer will not pick it up, nor will it execute the package if I put the name of the Environment in manually. I have tried: - Restarting the SSIS IR (repeatedly) - Multiple refreshes of the metadata - Building the process from scratch - Adding a new project (this cannot pick up even the existing environments) It acts like the ability for ADF to pick up Environments from the SSIS Catalog is broken. ![159457-image.png][1] [1]: /api/attachments/159457-image.png?platform=QnA
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hi anonymous user,
Thanks for using Microsoft Q&A !!
I have tested this in my SSIS-IR and I am able to select the environment as expected. (See screenshot below)
My SSIS-IR is in West US. Are you still having this issue? In which region you are having your SSIS IR ?
Thanks
Saurabh
Hi anonymous user,
We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Thanks
Saurabh
Hi Saurabh - I have just checked and the issue is persisting. Behaviour is very odd:
1) I have added a new project to use the new configurations - it cannot see any configurations
2) The existing project can only see the original configuration.
Note these behaviours are seen after refreshing the SSIS Catalog using the button in ADF to pull back latest metadata.
Our IR is Australia East, as is the Azure SQL DB hosting SSISDB
Appreciate your help!
@Saurabh Sharma - any ideas?
Hi anonymous user,
Sorry I missed this. I don't think of any specific reason for this behavior. I suggest you to please open a Azure Support ticket so that an engineer can look into this issue.
In case you have any limitation opening a support case please let me know and I will help you providing a free one time support ticket.
Thanks
Saurabh
Thanks to @Saurabh Sharma this issue is resolved.
For anyone else facing this problem, it was a configuration issue - because the Environment was not configured as a Reference in the SSIS Catalog, ADF would not recognise it for that project.