While Importing a flat file containing 151 columns to SQL Database we are getting an exception.
"SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007000E.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x8007000E Description: "Not enough storage is available to complete this operation."
Failed to open a <g class="gr_ gr_18 gr-alert gr_spell gr_inline_cards gr_disable_anim_appear ContextualSpelling" data-gr-id="18" id="18">fastloadrowset</g> for "[dbo].[TestTable]". Check that the object exists
in the database."
When columns reduced 131 in SQL it's working. Is it a limitation of SSIS data access mode "Table or view - Fast load" option.
Thanks,
Arun
Moved byDave PatrickMVPTuesday, December 18, 2018 1:40 PMlooking for forum