[BulkInsert] [Bulk Insert] Specified cast is not valid

Forge Component
(16)
Published on 23 Aug (4 weeks ago) by João Pedro Abreu
16 votes
Published on 23 Aug (4 weeks ago) by João Pedro Abreu

Hi guys,

I have the error "Specified cast is not valid" when I try to insert Null Values for a reference column, even if I put that column on the "ReferenceColumns".

Does anyone know how to solve it or if it is a bug?


Thanks in advance,

Diogo Miguel

Hi Diogo,

Which Database provider are you using? NULL values for reference columns are only implemented for SQL Server, at the moment.

Solution

Actually, I think that's an error that I already had in my TO FIX list.

Please try the attached version of the component and let me know if it fixes your problem.

Solution

Hi João,

Thank you for the quick reply.

It worked :)

Thanks,

Diogo Miguel