Azure Synapse Analytics - Can not create SSIS IR

Jens 36 Reputation points
2023-03-10T08:52:12.1733333+00:00

According to the documentation, the SSIS Integration Runtime is in public preview for Azure Synapse Analytics and I should be able to create an SSIS IR in the management tab (https://learn.microsoft.com/en-us/azure/data-factory/create-azure-ssis-integration-runtime-portal?tabs=synapse-analytics). However, I can only choose to create either an Azure or self hosted IR. I can not specify the "type" or select SSIS anywhere. Similarly, in pipeline creation, I do not see the "Execute SSIS package" activity, which is displayed, e.g., in this tutorial https://www.youtube.com/watch?v=PdsnoDnEDJI&t=164s

Our Synapse workspace (West Europe) has data exfiltration protection enabled. It is therefore part of a managed vnet. Is this maybe a limitation that is missing in the documentation, such that the public preview functionality is missing? Do I need to activate this feature set somewhere? I could not find any information on this.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,472 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Jens 36 Reputation points
    2023-03-10T08:59:46.17+00:00

    Turns out I had an outdated IP enabled for workspace access. The creation wizard shows the SSIS option only with a correct IP whitelist. Strange behavior.


  2. ChunhuaGu-MSFT 1 Reputation point Microsoft Employee
    2023-03-14T06:36:25.88+00:00

    This is a bug. Fix should be available this month. Would you please open support ticket if you still experience this issue after?

    Thank you for the feedback.

    0 comments No comments