April 24, 2017 at 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
April 24, 2017 at 8:45 am
info 58414 - Monday, April 24, 2017 8:05 AMHi,
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply