OLE DB Command Not Working

Hello,

I've created an ssis package that copies or updates data from a table to another.

Essentially I have

DB source

Lookup

conditional split --> update changed rows ole db command

|
|

write new rows to database ole db command


The write new rows command will not work, VS says it executed fine, but no rows are written to the table

I'm trying to get this package to update the modified rows and write the new rows to the table

I tried a simple

insert into table(a,b)
select a,b from othertable
where a = ?

but this didn't work

I then tried the following command ( this command works if run on SQL server management studio):

Insert into mytable ( a,b)
select CB.a, CB.b
from database_A.dbo.CB CB
left join database_B.dbo.CS CS
on CB.a = CS.a
where CS.a is null and CB.a = ?

The database connection manager points to database_B

The table that I'm trying to insert the data to has a primary key constraint on a.

It's a bit annoying to have to go through this process manually


Any ideas why this isn't working?

TIA