SSIS #107 – Parameterized Query in OLE DB Data Source: parameter information cannot be derived from SQL statements with sub-select queries

I have a few posts blogging about how to pass variables into parameterized queries into Execute SQL Task and OLE DB Data Source in a data flow. SSIS #101 – Use expressions to pass parameters to ADO.NET Source SSIS #99 – Pass a date time parameter to the Execute SQL Task SSIS – Pass a … Continue reading SSIS #107 – Parameterized Query in OLE DB Data Source: parameter information cannot be derived from SQL statements with sub-select queries