Problem when creating package for exporting SQL Server table to excel with SSIS

I'm fairly new to SSIS, so please have some patience :)

I'm trying to export a table or stored procedure (in this case a table since it's easier) to excel but I'm getting error when executing the package, the server is a SQL Server and I'm connecting using the OLE DB Source.

This is the error I'm getting:

SSIS package "C:\xxx\Integration Services Project3\Package.dtsx" starting.

Information: 0x4004300A at Data Flow Task 1, SSIS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task 1, SSIS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task 1, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task 1, SSIS.Pipeline: Pre-Execute phase is beginning.

Error: 0xC0202009 at Data Flow Task 1, Excel Destination 1 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.

An OLE DB record is available.
Source: "Microsoft Access Database Engine" Hresult: 0x80040E21
Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "worker_reference" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "placement_reference" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "worker_name" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "job_title" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "authorising_line_manager" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "company_agent_name" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "type_of_worker" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "hours_worked" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "rate_description" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "rate_per_hour" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "job" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "work_stage" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "project_name" column. The binding status was "DT_NTEXT".

Error: 0xC002F445 at Data Flow Task 1, Excel Destination 1 1: An error occurred while setting up a binding for the "location" column. The binding status was "DT_NTEXT".

Error: 0xC0202025 at Data Flow Task 1, Excel Destination 1 1: Cannot create an OLE DB accessor. Verify that the column metadata is valid.

Error: 0xC004701A at Data Flow Task 1, SSIS.Pipeline: Excel Destination 1 failed the pre-execute phase and returned error code 0xC0202025.

Information: 0x40043008 at Data Flow Task 1, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x4004300B at Data Flow Task 1, SSIS.Pipeline: "Excel Destination 1" wrote 0 rows.
Information: 0x40043009 at Data Flow Task 1, SSIS.Pipeline: Cleanup phase is beginning.

Task failed: Data Flow Task 1
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (17) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "xxx\Integration Services Project3\Package.dtsx" finished: Failure.
The program '[6128] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

I'm not sure if may have anything to do with the connection or the columns I'm creating in Excel, the workbook has the same columns as the database table.

Maybe what I'm doing wrong is the mapping, I've tried with a data conversion in the middle, but I keep getting otherwise the error "cannot convert between unicode and non-unicode.."

I'm adding bit more info regarding configurations:

This is the default configuration the data convert has:

This is the default mapping in the excel output:

And changing all the data convert data types from text stream [DT_TEXT] to Unicode text stream [DT_NTEXT] is what allows me to be able to run it and gives me the error shown above