I suggest you always provide the full error text. Otherwise let me shoot in the dark: I think the error is for the OLE DB component trying to deliver a column to the target table and the target database won’t accept the input data type. The component has allowed the mapping because it should / might work but when it tries to execute all breaks.Arthur My Blog

I have a execute sql task ,the query is set identity_insert dbo.test on go merge dbo.test as target using(select * from dbo.test2) as s on target.id=s.id when matched then update set name = s.name when not matched then insert(id,name) values(i.id,i.name); set identity_insert dbo.employer off GO This works fine in SSMS but does not work in ssis execute sql task, the error i see is multi-step oledb operation generated errors.check each oledb status value--- Any thoughts?

I suggest you always provide the full error text. Otherwise let me shoot in the dark: I think the error is for the OLE DB component trying to deliver a column to the target table and the target database won’t accept the input data type. The component has allowed the mapping because it should / might work but when it tries to execute all breaks.Arthur My Blog