question

arkiboys avatar image
0 Votes"
arkiboys asked ShaikMaheer-MSFT commented

execute ssis

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

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered ShaikMaheer-MSFT commented

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://docs.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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @arkiboys ,

Just checking in to see if the below answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·
VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered arkiboys commented

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

https://docs.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

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
What is the alternative?
Thanks

0 Votes 0 ·

Use ADF and later migrate to Synapse when SSIS support is available.

0 Votes 0 ·
arkiboys avatar image arkiboys VaibhavChaudhari ·

In that case, as I am limited in synapse workspace, Is it possible to call ADF inside SSIS?

0 Votes 0 ·