I am trying to generate an XML file using SSIS and I get this error:
[OLE DB Source [19]] 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: "Memory allocation failure".
It generates a output when I run it on a subset of data.
The expected row count is to be around 7 million records. It was also working for 7 million records when there were around 9 columns. Recently I added 2 more columns and this error shows up.
What would be the optimal buffer settings to resolve this error?
Thank you
User contributions licensed under CC BY-SA 3.0