CODEWITHSUNDEEP
azuressisazure-data-factory
nick
nick

Reputation: 333

xp_xmdshell azure data factory

I am wondering if I use SQL Server stored procedure inside "Execute SQL Task" in SSIS and this stored procedure uses xp_cmdshell. Now if I want to create Azure Data Factory pipeline for the same task, how do I achieve that?

Also I have some C# readonly and readwrite variables inside my SSIS, How do I convert them in ADF?

Upvotes: 1

Views: 140

Answers (1)

Jay Gong
Jay Gong

Reputation: 23782

Microsoft says you can use Custom tasks and achieve anything but how??

For you situation,maybe you could use Stored Procedure Activity to run your SSIS package.Please see this link: https://learn.microsoft.com/en-us/azure/data-factory/how-to-invoke-ssis-package-stored-procedure-activity

For that,you need to configure Azure-SSIS integration runtime,not default Azure IR.

Upvotes: 0

Related Questions