Post reply

Cancelling pipeline condition based

  • October 10, 2019 at 7:41 pm

    #3687846

    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

    #3687898

    Is this an ADS pipeline? What is your IF condition? How is the source data structured?

  • October 11, 2019 at 5:38 am

    #3687928

    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