CODEWITHSUNDEEP
azureazure-sql-databaseazure-data-factory
Kamal Preet Saini
Kamal Preet Saini

Reputation: 7

Passing single record to Copy Activity

How to pass record by record in a sequential manner to a Copy Activity (including stored proc) in ADF V2

Upvotes: 0

Views: 244

Answers (1)

Martin Esteban Zurita
Martin Esteban Zurita

Reputation: 3209

You can do this by doing a lookup activity calling your sp, then do a foreach where each item is a record. Inside the foreach, you can have a copy activity where you insert only that row.

This way of working will have a ton of overhead time!! Also it will use a ton of activities making your whole money consumption on Data Factory much more expensive than it needs to be. Only apply it when its super mandatory, and warn everyone about the cost so you dont get into trouble.

Maybe if you could share a bit more on your scenario we are able to suggest a better process.

Hope this helped!!

Upvotes: 1

Related Questions