Error converting TinyInt

[dinamap]

Hi,

I'm testing your trial version, and is a great product. But while doing a bulk insert with COPY, an error appears with the following message: "Convertion of type 17 to string failed (bt=2, ord=15, tbl="TABLE")" The column 15 has type TinyInt.

With value sets there is no error, and the column is fully copied.

Thanks.

[Moderator]

Hi,
are you inserting rows via a linked server? Would you send more details/instructions on how to reproduce the issue?

Thank you!

[dinamap]

Hello,

Sorry for the missing details. For my first tests, I've used the SSIS Wizard with PGNP as the destination connection. In the Advanced Properties for that connection, I selected "Copy command" for the "Bulk Insert Method" property.
Then I selected a table containing a tinyint (DT_UI1) datatype column, and checked the box to drop and recreate the destination table in the Column Assignments dialog box, because the table was already copied before.
After that, running the package results in an error with the message: "Convertion of type 17 to string failed (bt=2, ord=15, tbl="MY_TABLE")"

Thanks.

[Moderator]

We've fixed the bug and uploaded the trial module to http://www.pgoledb.com/downloads/PGNP-1.3.0.2129.exe.

Thank you for finding the defect!

[dinamap]

I'm glad to help you, and thank you for the quick fix. I'll keep testing.