I had a successful OLE DB Update command: UPDATE EDW.[T120_PartyLocatorRelation] SET [PartyLocatorRelEndDtime] = ? ,[ProcessLogId] = ? WHERE [PartyId] = ? AND [PartyLocatorRelCode] = ? AND [PartyLocatorRelEndDtime] IS NULL (I do understand that OLE DB Command is not the most efficient method of updating for many rows, but would prefer to stick with this at the moment.) However I discovered that it was updating multiple rows and needed to be further qualified by a join to another table to restrict it. UPDATE EDW.T120_PartyLocatorRelation SET PartyLocatorRelEndDtime = ? ,ProcessLogId = ? FROM EDW.T120_PartyLocatorRelation plr INNER JOIN EDW.T204_VirtualLocation vl ON plr.LocatorId = VirtualLocId WHERE PartyId = ? AND PartyLocatorRelCode = ? AND vl.VirtualLocTypeCode = ? AND PartyLocatorRelEndDtime IS NULL This query works fine in SQL Server Management Studio when I add in values. In SSIS, I have added the additional parameter and mapped the column to a data item in the input, but I get an error when I OK it. Error at Load Rows without Bookmark [OLE DB Command [15216]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source "Microsoft OLE DB Provider for SQL Server" Hresult: 0x8000405 Description: "Invalid column name 'VirtualLocTypeCode'.". What am I doing wrong?

If the query actually runs in SSMS then I'd suggest deleting your OLEDB command and recreating it. Might just be that the component is in a bad state from the change.Chuck Pedretti | Magenic North Region | magenic.com

have you connected to right database?http://uk.linkedin.com/in/ramjaddu

create a stored procedure, put your update statement inside and call it in oledb command component. This way, you will also have the opportunity to modify it without opening the ssis package; which is the best practice; and able to see the parameters in oledb command component editor window.Senior BI Consultant & PM @ Bicentrix If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.