You have a couple of options.

One is to use a Lookup transform where you send the "error rows" (rows where a match is not found) on to the Destination Component. You would need to Configure the error mode to redirect row.

The other, which will usually perform better is to insert all the rows into a staging table in the same database and then do a Left Outer Join on the destination.