CODEWITHSUNDEEP
.net-coreazure-data-factory
arpan desai
arpan desai

Reputation: 909

Azure Data Factory v2 set pipeline name dynamically using expression in Execute Pipeline activity

Can we use expression in Execute Pipeline's 'Invoked pipeline' field?

Basically I have list of Pipeline name in SQL Database and I want to execute pipeline in ForEach activity of ADF V2. So if somehow we can set variable and might use it in Invoked Pipeline field! This field is drop down with existing pipeline name.

Upvotes: 2

Views: 4118

Answers (2)

Jay Really
Jay Really

Reputation: 95

Take care though, pipelines cannot have more than 40 activities, so this would limit the number of possible invoked pipelines to 20 (assuming a bare setup with 20 IF activities, and one

As per https://github.com/MicrosoftDocs/azure-docs/blob/master/includes/azure-data-factory-limits.md :

Maximum activities per pipeline, which includes inner activities for containers: 40

Upvotes: 2

Atvoid
Atvoid

Reputation: 187

Expression is diabled in the property of 'Invoked pipeline'. This field must be static value. The reason is that this may cause a security issue, and cause an infinite loop.

To work around, you can create several IF activity within the Foreach activity, and each IF activity contains an Execute Pipeline activity, once the IF condition matches the pipeline name, it will go to the next step.

Upvotes: 0

Related Questions