issues updating records in ssis using lookup and oledb command im working on an ssis project loading data between two sql azure databases that is updating matching records and inserting new records between them using a lookup and ole db command but I'm getting an error on the ole db command as the following, any ideas what it may be? trying to update over 20,000 records
[OLE DB Command [28]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: &quot;Microsoft SQL Server Native Client 11.0&quot; Hresult: 0x80004005 Description: &quot;Communication link failure&quot;.
An OLE DB record is available. Source: &quot;Microsoft SQL Server Native Client 11.0&quot; Hresult: 0x80004005 Description: &quot;TCP Provider: The semaphore timeout period has expired.
It seems like this could be a bug in OLE DB for SSIS. Could this solution be the one you're looking for?