locked
Can we replace using Data factory RRS feed

  • Question

  • Hi,

    We are planning to bring encrypted data over to Azure SQL using Data Factory. Can we do a full replace using Data Factory or atleast delete and insert (using copy or custom activity). I am new to Visaul studio and hence looking for some ETL like capability.

    Thanks!

    Monday, April 13, 2015 3:36 PM

Answers

  • You can specify the property "SqlWriterStoredProcedureName" and "SqlWriterTableType" in SqlSink, and add the merge logic in your own stored procedure. Notice that don't use a simple delete operation in the stored procedure, as it may be called several times in a single Copy.

    For more information about how to use this feature, refer to this post.

    • Marked as answer by NewBeeMS Thursday, April 23, 2015 4:23 PM
    Thursday, April 16, 2015 5:33 AM

All replies

  • You can specify the property "SqlWriterStoredProcedureName" and "SqlWriterTableType" in SqlSink, and add the merge logic in your own stored procedure. Notice that don't use a simple delete operation in the stored procedure, as it may be called several times in a single Copy.

    For more information about how to use this feature, refer to this post.

    • Marked as answer by NewBeeMS Thursday, April 23, 2015 4:23 PM
    Thursday, April 16, 2015 5:33 AM
  • I will try this. Thanks.
    Thursday, April 23, 2015 4:23 PM