My setup is - SSMS connecting to Azure SQL server. This server has deployed on it a number of SSIS packages to be run.
When a package is under execution, I have the error shown below:
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: "Resource ID : 1. The request limit for the database is 60 and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance."
.
After doing much research, I found that a potential solution was to decrease the MAXDOP amount. Set the value between 1 or 0. Doing this had no effect and did not prevent the error message.
Then, also as a result of research, I found out that I could restart the SQL services running. This ensured the SSIS package I execute could complete without errors twice! But on third attempt, the execution processes failed with the above error.
I found out online that there could be other reasons why I'm getting this error. Any chance someone can assist by pointing me in the right direction.
Many thanks Thanks.
There was a package with a data-flow task in it. This task was writing to over 30 table simultaneously. In the end, I broke the task down into mini tasks, to reduce the number of simultaneous db access.
This solved my issue.
User contributions licensed under CC BY-SA 3.0