locked
Automation Store Procedure Data Factory later of copy table RRS feed

  • Question

  • Hi guys,

    It is possible schedule a execute store procedure by data factory later that copy finished?

    For example:
    I have a data factory that do copy of table A (local) for table B (SQL Database Azure) I would like schedule a new process for start just when this copy finished, this new process will execute a store procedure

    It is possible?



    • Edited by fit9 Thursday, January 26, 2017 12:02 PM
    Thursday, January 26, 2017 12:01 PM

All replies

  • Please see this page about creating a Stored Procedure activity:

    https://docs.microsoft.com/en-us/azure/data-factory/data-factory-stored-proc-activity

    Note the json example for the activity -- it lists one output dataset, "sprocsampleout". This dataset will be used to indicate the execution status for each slice (each time the sproc activity runs). To integrate this activity into your pipeline, you would add to the json under outputs a section like:

    "inputs": [
      {
         "name": "name of Copy output dataset"  }
    ],

    Even though that dataset is not consumed by the sproc activity, specifying it as an input introduces a dependency order so that the sproc activity will be triggered after successful copy activity.

    Thursday, January 26, 2017 5:48 PM