Share via

execute ssis

arkiboys 9,686 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,696 questions
0 comments
Accepted answer
  1. ShaikMaheer-MSFT 38,401 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
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,686 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