In my SSIS dataflow I am inserting values into a staging table. When performing the update query in the control flow, to update values from my staging table in the final table, I am having trouble executing my SQL query.
It look like this
UPDATE final set Value = staging.Value
WHERE final.Id = staging.Id
AND final.ValDate = staging.ValDate
AND final.ForDate = staging.ForDate
It gives me an error:
Error: 0x0 at Update: The multi-part identifier "staging.Id" could not be bound.
Error: 0x0 at Update: The multi-part identifier "staging.ValDate" could not be bound.
What is wrong? Any inputs?
View Complete Post