Forum Discussion
we cannot convert the value null to type logical...
I am getting the error "we cannot convert the value null to type logical..". The problem is that it tells me what table when trying to load but it does not tell me what column nor does it create an e...
Hi All, hopefully this has already been resolved but if not hopefully this helps:
1: Source is an excel workbook- A blank cell in Excel and a cell with a space in it is not a null.
Easiest way to check IMHO is as per below.
Anonymous same can be said for SQL- If you are querying SQL, try adding to your where clause
Where <ColumnName> IS NOT NULL
This will remove the rows causing this issus.
If you need to include, try adding in a case statement to inspect the column
Case when <ColumnName> Is NULL then 1 else 0 end as IsnullValue