Import Data error from Excel

olafhelper 

Good morning,

I'm really sorry for the screenshot. Kindly check the error with this text.

Copying to [dbo].[Aug2023M] (Error)
Messages
Information 0x4004800c: Data Flow Task 1: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 9 megabyte(s) in 3 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 14 buffers were considered and 14 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 6 megabyte(s) in 2 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 12 buffers were considered and 12 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x40048010: Data Flow Task 1: Component "Source - 'Aug 2023 M$'" (1) owns 3 megabyte(s) physical buffer.
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 14 buffers were considered and 14 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 14 buffers were considered and 14 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 14 buffers were considered and 14 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 14 buffers were considered and 14 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Information 0x4004800d: Data Flow Task 1: The buffer manager failed a memory allocation call for 3145480 bytes, but was unable to swap out any buffers to relieve memory pressure. 14 buffers were considered and 14 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.
(SQL Server Import and Export Wizard)

Information 0x4004800f: Data Flow Task 1: Buffer manager allocated 3 megabyte(s) in 1 physical buffer(s).
(SQL Server Import and Export Wizard)

Error 0x8007000e: Data Flow Task 1: Not enough storage is available to complete this operation.
(SQL Server Import and Export Wizard)

Error 0xc02020c4: Data Flow Task 1: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
(SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Source - 'Aug 2023 M$' returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

Thanks,

Shabin