Login or sign up Lost password?
Login or sign up
Update Destination Table @ID int, @Firstname nvarchar(50), @Lastname nvarchar(50)ASBEGIN SET NOCOUNT ON; update Upsert Destination Table set [email protected], [email protected] where [email protected] then add an OLEDB Command transform to the data flow task, and connect the Match Output from lookup transform to the OLEDB Command, go to OLEDB Command Editor, in connection managers tab, set the connection manager to destination database, in component properties tab, go to sql statement property, and write this update statement there: Note that question marks are parameter markers, and each of them represent a parameter, then you can map input columns to these parameters in the column mappings tab, That's all.