Error converting TinyInt

More
10 years 6 months ago #200 by dinamap
dinamap created the topic: Error converting TinyInt
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.

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

More
10 years 6 months ago #202 by Moderator
Moderator replied the topic: Re: Error converting TinyInt
Hi,
are you inserting rows via a linked server? Would you send more details/instructions on how to reproduce the issue?

Thank you!

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

More
10 years 6 months ago #208 by dinamap
dinamap replied the topic: Re: Error converting TinyInt
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.

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

More
10 years 6 months ago #210 by Moderator
Moderator replied the topic: Re: Error converting TinyInt
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!

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

More
10 years 6 months ago #211 by dinamap
dinamap replied the topic: Re: Error converting TinyInt
I'm glad to help you, and thank you for the quick fix. I'll keep testing.

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

Time to create page: 0.071 seconds
Powered by Kunena Forum