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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy