SSIS Flat File Import : Error while importing file contains 151 columns RRS feed

  • Question

  • Hi,

    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.


    • Moved by Dave PatrickMVP Tuesday, December 18, 2018 1:40 PM looking for forum
    Tuesday, December 18, 2018 6:29 AM