Merge with DataSource is a Dataflow-Task

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  April 24, 2017 at 8:05 am

  #336611

  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

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  April 24, 2017 at 8:45 am

  #1939558

  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.

  ---