execute ssis

arkiboys 9,616 Reputation points
2022-01-16T15:07:32.317+00:00

In synapse workspace, I created a pipeline but do not see an activity to execute ssis package.
Any suggestions?

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. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-01-18T13:17:59.77+00:00

    Hi @arkiboys ,

    Thank you for posting query in Microsoft Q&A platform.

    I shared details on similar kind of ask at below link. Requesting to check it and let us know if any further queries.
    https://learn.microsoft.com/en-us/answers/questions/695582/ssis-to-execute-adf.html

    Hope this will help.

    ----------

    Please consider hitting Accept Answer button. Accepted answers helps community as well.


1 additional answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,576 Reputation points
    2022-01-17T05:39:59.27+00:00

    At this moment, running SSIS package is not supported in Azure Synapse pipelines. You will have to use ADF for now.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/concepts-data-factory-differences#available-features-in-adf--azure-synapse-analytics

    Consider upvoting the feature - https://feedback.azure.com/d365community/idea/475f5da0-0925-ec11-b6e6-000d3a4f07b8

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav