Invalid Cursor state when trying to update SQL

Hi Team,
I seem to be going nuts , I have simple command in my transformation , MasterTaskID is the primary key which has been selected as update key also

UPDATE target
SET target.freq_e1 = source.freq_e1,
    target.freq_e2 = source.freq_e2
FROM [items].[basecamp].[checklist_master] AS target
JOIN (VALUES (?, ?, ?)) AS source (MasterTaskID, freq_e1, freq_e2)
    ON target.MasterTaskID = source.MasterTaskID;


I consistently get Invalid cursor state 24000

When I try to do in manually  in SQL editor window, it works fine 


UPDATE target SET target.freq_e1 = source.freq_e1, target.freq_e2 = source.freq_e2 FROM [items].[basecamp].[checklist_master] AS target JOIN (VALUES (1011,'appa', 'bappa')) AS source (MasterTaskID, freq_e1, freq_e2) ON target.MasterTaskID = source.MasterTaskID;

same error for default update

please try using set sql nocount on

We will update documentation to make life of everyone easier 

it works !!

omg , that's almost 45 minutes of my life gone on trying to sort this.

Thanks a lot for quick revert !