problems with binary in SSIS

I have installed "PGNP-Postgres-SE-Trial-1.4.0.3542-x64". And tried an SSIS package to copy from MSSQL to POSTGRESQL.
I have problems for varbinary field on MSSQL side and bytea on PG. I see DT_BYTES on MSSQL side and DT_IMAGE on PG. The driver couldn't do data cast and left the fields empty.
Then I do cast to image on MSSQL and data was copied.
But it only worked when balk mode is "Value Set". From other modes more or less worked "Text Copy" but for some data it is giving "ERROR: invalid byte sequence for encoding "UTF8".

1. What type on PG side will be equivalent to DT_BYTES

2. is it the intended behavior for DT_IMAGE not to use any bulk method?

thanks.

This looks like a bug in build 3542. The recommended method is FastLoad. If FastLoad is not used then the old/deprecated method is to use BULK_INSERT=2000;BULK_METHOD=COPY; in the Extended Properties of the connection string.

We are going to reproduce the issue and will work on fix. If you want to speed up, please send DDLs and additional details to our Support. Thank you!

I have built a VS 2017 project with the bugs.

github.com/nshanb/Intellisoft-OLE-DB-Provider-Tests

Thank you for the test solution! We are investigating the issue(s). I will update the thread with results.

hi, is it possible that licensed version has no the described bugs?