Merge with DataSource is a Dataflow-Task

  • Hi,
    Is it possible to specify the content of a dataflow task as DataSource instead of a table in a merge statement?
    Do I need to create a temporary table?

    MERGE Table1 t
    USING col1, col2 from DataFlow....  (not a SourceTable)

    Regards

    Nicole

  • info 58414 - Monday, April 24, 2017 8:05 AM

    Hi,
    Is it possible to specify the content of a dataflow task as DataSource instead of a table in a merge statement?
    Do I need to create a temporary table?

    MERGE Table1 t
    USING col1, col2 from DataFlow....  (not a SourceTable)

    Regards

    Nicole

    Not possible. Send the results of your dataflow to a (newly truncated) staging table and MERGE from that, if you are happy to tolerate the numerous issues with MERGE, that is.


Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply