How to restrict rows from SSIS Data Source?

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 开发者_Go百科SSIS?

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.

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