John, building the variable as the query containing the values is a decent idea, and may in the end decide to go that route. However, this seems like it should be so simple, I almost feel like I can't let it defeat me.

I attached 2 queries. One that I am using as a SQL command as a variable, and the second would be just a SQL command passing in the variable in the OLE DB Source.

Thanks for your help and suggestions.