conversion failed when converting the nvarchar value to data type bit

[sharlotte]

Good day, I'm getting an error when I'm inserting to my standard table. The below is the code that I have

Insert into Bidvest.dbo.[Bidvest Database] ([Item], 
  [Cardholder Name], 
  [Date Collected], 
  [Type], 
  [Address1],
  [Address2],
  [Address3],
  [Address4],
  [Work],
  [Home],
  [Cell],
  [Plastic Number],
  [ID Number],
  [Cardholder ID],
  [Company],
  [CardType],
  Delivery_Method,
  [Cardholder Proof of Residence]
  )
Select r.Main_Link,
	   r.ClientName,
	   CCDCommon.dbo.DateOnly(Getdate()),
	   'Wealth',
	    r.Address1,
	    r.Address2,
	    r.Address3,
	    r.Address4,
	    r.Work,
	    r.Home,
	    r.Cell,
	    r.UniqueRef,
	    r.ClientIDNumber,
	    cast(r.Branch as nvarchar(500)),
	    r.CardType,
	    r.[Type],
	    case when  r.IDIndicator = 'Y' then 1 else 0            end,
	    case when  r.PORIndicator = 'Y' then 1 else 0            end
            From Bidvest.dbo.[ImportData_Wealth] r left join [Bidvest Database]  d 
on cast(r.[Main_Link] as nvarchar(250))= cast(d.[Item]as nvarchar(250))left join CCDArchive.dbo.[BidvestDatabase] a on a.[Plastic Number] = r.CardRef 
and a.Type = 'Wealth'
Where r.CardType = 'Electron Card'
and r.[ImportDate] is null 
and d.Item is null
and a.Item is null

but I get the below error:

Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the nvarchar value 'RMB PRIVATE BANK JOHANNESBURG - JHB' to data type bit.

[sharlotte]

Sorry I'm sorted now.