How to restrict rows from SSIS Data Source?

Question

I have an OLE DB Data Source in an SSIS package. I want to restrict rows to return data from a specific date (it has a date column). How can this be achieved in SSIS?

Answer 1

I changed the "Data Access Mode" property of the "OLE DB Source" component to "SQL Command" and specified a where clause in the TSQL statement.

Answer 2

You could use a conditional split control or a script task.