title: SSIS - dynamic query into ado net source
body: <p>I have a DWH project, the source system is a MySQL database, ETL is SSIS and the datawarehouse is SQL server.
  The problem: we have a huge fact table in MySQL database, that we extract through a query with some date filtering, nothing special. Due to stupid business processes there are some records that get into the table with no flags or modified dates, so the query can't extract it. Long story short we could identify those rows by some comparing, and storing the missing row's 2 most important dimension in the stage layer.
  Now the real problem is that I would like put the concatenated values of this tables into the ADO net source query to filter the necessary data. Is there any way to achive this?</p>