issues updating records in ssis via look up and oledb command

0

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: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Communication link failure".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: The semaphore timeout period has expired.

data flow setup as follow

sql
ssis
lookup
oledbcommand
asked on Stack Overflow Dec 16, 2020 by HappyCoder123

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0