locked
Conditional Execution RRS feed

  • Question

  • Hi

    I wonder if there is a way to run an activity conditional? I want to export data from an azure SQL database to azure Blob Store.

    The Export should run daily - I have scheduled it successfully. But the Export should only create the blob file if there are records returned by the source query. (Select * from TAble where DATECOL=SliceEnd). If the Result is empty then I would like the file not to be crated.

    I could put a policy there, but this would raise an error, but I do not want an error to occure.

    (https://azure.microsoft.com/en-us/documentation/articles/data-factory-create-datasets/#Policy)

    Is there any  way to do this out of the box? (or is the only way a custom activity)

    Thanks for your help.

    Regards

    Hannes


    http://www.hmayer.net/

    Friday, November 13, 2015 10:19 AM

All replies

  • Yes, currently a 0 KB file would get created if the query does not result in any data.

    We are considering ways to provide options for users to override it.  

    Thanks, Harish

    Friday, March 11, 2016 1:38 AM