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

Forge Component
(18)
Published on 2 Oct by José Galter
18 votes
Published on 2 Oct by José Galter

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