Should not the answer be

r'D:\SQLServerBackup\MSSQL13.SQL2016\MSSQL\Backup'

instead of

r'D:SQLServerBackupMSSQL13.SQL2016MSSQLBackup'?

Small correction - column name in OuterVal is valueid, not id

SELECT s.*

FROM dbo.Stocks s

WHERE s.id IN ( SELECT o.valueid

...

As was mentioned before one of solutions is to add a script task to check if file exists.

If you decide to use that approach this may help:

1. create boolean variable...