How to Use Stored Procedure in Azure Data Factory with Parameters - Azure Data Factory Tutorial 2021

How to Use Stored Procedure in Azure Data Factory with Parameters - Azure Data Factory Tutorial 2021, in this video we are going to learn How to Use Stored Procedure in Azure Data Factory with Parameters - Azure Data Factory Tutorial 2021, Azure Data Factory Step by Step - ADF Tutorial 2021 - ADF Tutorial 2021 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2021
Script used in the video :
create procedure dbo.sp_Delete_Orders
@Region varchar(100),
@Country varchar(100)
as
BEGIN
Delete from dbo.[Order] where
Region=@Region
and Country=@Country
END
Azure Data Factory Tutorial for beginners
Azure Data Factory Tutorial 2021
Step by step Azure Data Factory Tutorial
Real-time Azure Data Factory Tutorial
Scenario base training on Azure Data Factory
Best ADF Tutorial on youtube
#AzureDataFactory #ADFTutorial2021

[@MubinKhanLodhi]

You're a lifesaver ... Thanks a lot :)

[@oiwelder]

for sure man.

[@saktibiswal6445]

Thanks, helped a lot. With the new version of Azure data factory (Jul 2024) this method needs a little tweak. Adding dynamic content from dropdown or GUI does not work anymore. Instead one as to enter a string example .pipeline().parameters.

[@sravankumar1767]

Nice explanation bro

[@iedadl]

Thank you!

[@SurajitMetya]

The same task can be performed using Lookup too right?

[@shantanuchatterjee9056]

Thank you sir - it helped a lot 🙂

[@TechBrothersIT]

sure. thank you

[@yedukondalu9100]

can we directly delete by using sql query and use script activity in ADF .
delete from emp where country ='india' and region= 'asia' --- use this query in script activity