October 10, 2019 at 7:41 pm
I have created a pipeline to move the data from on-premise to Azure VM.
There are instances that we don't have data in the source.
I am using the If activity and looking for if we can stop the further execution of the Pipeline or cancel the pipeline if there are no records in the source.
Please suggest.
October 10, 2019 at 11:53 pm
Is this an ADS pipeline? What is your IF condition? How is the source data structured?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 11, 2019 at 5:38 am
Hi Steve,
It's ADF pipeline.
Source is a table in Sql server having 10 million records appx. Source Table is truncated each day and fresh data is loaded into it. We have to move the data to Azure VM on daily basis.
I just want that before starting the pipeline it just checks if there are records in the Source Table.
If record count is zero then it must stop the execution of the pipeline.
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply