Okay...  last one I'm going to do.   You should be able to see what's being done here and start asking questions about what parts you don't understand:
CREATE TABLE dbo.TABLEA...

You've got a data problem.   You changed the PersonID values so that one of them has no match in TABLEB..

Okay, so have you used a parameter that actually matches a value in the table being selected from?

I too am not sure about the proper solution, as your original data has duplicated values.   Here's what I came up with, after assuming that the duplicates are valid:

Why not create a Script Task in VB language within an SSIS package, that runs the LDAP query results either into a SQL Server table using ADO code, or into...

As long as you're creating a view, you will not be able to parameterize your query.   Views don't have that functionality.   If you need to use parameters, then you have...