I figured out how to do this. But now all my data is going to the error output.

I'm only doing 10 rows as a test and I looked at my data from the source

For example the one home phone is

999-8177

And I did the following in Sql Server

SELECT PhoneRawUnencrypted.PhoneUid, PhoneRawUnencrypted.PhoneNumber

FROM ListPhoneType INNER JOIN

PhoneRawUnencrypted ON ListPhoneType.PhoneTypeUid = PhoneRawUnencrypted.PhoneTypeUid

WHERE (ListPhoneType.Name = 'home')

AND PhoneRawUnencrypted.PhoneNumber = '999-8177'

It returns the following

B79ED43A-D135-4C5A-8B11-64B4A2315762999-8177

So the data exist.

Why is it going to my error output?

Joe