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

Forge Component
Published on 2019-10-02 by Galter
19 votes
Published on 2019-10-02 by 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.


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.


Hi João,

Thank you for the quick reply.

It worked :)


Diogo Miguel