problems with binary in SSIS

More
4 months 1 week ago #14508 by nshanb
nshanb created the topic: 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.

Please Log in or Create an account to join the conversation.

More
4 months 1 week ago #14509 by admin
admin replied the topic: problems with binary in SSIS
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!

Please Log in or Create an account to join the conversation.

More
4 months 1 week ago #14510 by nshanb
nshanb replied the topic: problems with binary in SSIS
I have built a VS 2017 project with the bugs.

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

Please Log in or Create an account to join the conversation.

More
4 months 5 days ago #14511 by admin
admin replied the topic: problems with binary in SSIS
Thank you for the test solution! We are investigating the issue(s). I will update the thread with results.

Please Log in or Create an account to join the conversation.

More
3 months 3 weeks ago #14514 by nshanb
nshanb replied the topic: problems with binary in SSIS
hi, is it possible that licensed version has no the described bugs?

Please Log in or Create an account to join the conversation.

Time to create page: 0.081 seconds
Powered by Kunena Forum