ADF SSIS Runtime , ssis package task which don't support

sakuraime 2,326

Are there any tasks in the following SSIS package , which don't support to run on SSIS IR in Azure data factory . ?

sakuraime 2,326 Reputation points

2021-07-21T09:57:33.16+00:00

anyone has the idea ?

1 answer

KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee

2021-07-22T07:06:14.093+00:00

Hi @sakuraime ,

Thanks for your query.

In general, all tasks are supported by SSIS IR, while some are enterprise feature (like Fuzzy Grouping and Fuzzy Lookup etc.) needs to Provision Enterprise Edition for the Azure-SSIS Integration Runtime.

For detail list of preinstalled components, please refer to - Built-in and preinstalled components on Azure-SSIS Integration Runtime - Azure Data Factory | Microsoft Learn

For custom setup to install additional components, like drivers not installed by default, please refer to - Deploy and run SSIS packages in Azure - SQL Server Integration Services (SSIS) | Microsoft Learn

Hope this info helps.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.
Please sign in to rate this answer.
KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee

2021-07-23T19:18:45.627+00:00

Hi @sakuraime ,

Just checking in to see if the above info was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

sakuraime 2,326 Reputation points

2021-07-24T12:51:03.89+00:00

which connector is used to connect to oracle ? which one is used to execute powershell ? and what are the option of put the powershell script ?

KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee

2021-07-27T04:53:04.233+00:00

Hi @sakuraime ,

Thanks for your response. Could you please confirm if you are referring to ADF connectors? Appreciate if you could elaborate the ask.

If the ask is for ADF connectors. Below are the connectors:

For Oracle - Copy data from and to Oracle by using Azure Data Factory

For poweshell script execution, ADF doesn't have a out of box connector, but you can use Custom activity which can run the powershell script on an Azure Batch pool of virtual machines. For more info please refer to this doc: Use custom activities in an Azure Data Factory pipeline

KranthiPakala-MSFT 46,487 Reputation points Microsoft Employee

2021-07-30T07:13:27.903+00:00

Hi @sakuraime ,

Just checking to see if the above info was helpful or do let us know if you have further query.

Thanks
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

ADF SSIS Runtime , ssis package task which don't support

1 answer

Your answer