SAS IOM Data Provider - Transfer Error - SSIS connection

I have successfully connected to the SAS Server through the SAS IOM Data Provider. But when using the connection manager for the source connection I receive this error message when trying to transfer data to the destination table.

[OLE DB Source [29]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4E. [SSIS.Pipeline] Error: OLE DB Source failed the pre-execute phase and returned error code 0xC0202009.

The query I use is simple: select * from schema.table

I receive the column names from the table without any problem. But no data. I have tried to turn off pre validation, run the solution in 32-bit mode etc...

Edit 1: After going through the log files on the SAS server I can see that it could be related to UTF-8 vs Latin encoding.

Edit 2: I'm using the same connection string in Excel and it works there.

Edit 3: It works when choosing AccessMode OpenRowset from the Advanced Editor and then specifying the table there.