Azure Synapse Analytics - Synapse Pipeline SSIS Integration Runtime Support

Balan Murugan 41 Reputation points
2021-07-09T13:22:28.817+00:00

Hi Team,

Do we have any roadmap / SLA for having SSIS Integration Runtime support in Azure Synapse Analytics - Synapse Pipeline.

We have a customer requirements, where we have to modernize their existing on-premise MSFT tech stack (SSIS, SSAS, SSRS) with Azure Synapse Analytics to support their future analytics requirements via the unified experience from Synapse Analytics.

We are looking for an option to lift and shift their on-premise SSIS packages to Synapse Pipeline (Like how we have it for Azure Data Factory SSIS Integration Runtime)

Any guidance / help would be much appreciated.

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,360 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 76,836 Reputation points Microsoft Employee
    2021-07-12T08:55:01.19+00:00

    Hello @Balan Murugan ,

    Thanks for the question and using MS Q&A platform.

    Unfortunately, the Azure-SSIS Integration Runtime is not supported in Azure Synapse Analytics.

    113765-image.png

    For more details, refer to Create an Azure-SSIS integration runtime in Azure Data Factory.

    Currently, PG is working on this feature and it will be available soon.

    I will update this thread once it available. Stay tuned!

    Meanwhile, I would suggest you to provide feedback on the same:

    https://feedback.azure.com/forums/307516-azure-synapse-analytics

    All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

    Hope this helps. Do let us know if you any further queries.

    ---------------------------------------------------------------------------

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

    0 comments No comments

0 additional answers

Sort by: Most helpful