You can filter data before you tranfer it to other database. Here is the link where there is an good step wise step example.
* Data Flow Sources are ways that data gets into the system.
* Data Flow Transformations let you alter and manipulate the data in various ways. data flow transformations.
* Data Flow Destinations are the places that you can send the transformed data. flow destinations.
http://www.accelebrate.com/sql_training/ssis_tutorial.htm[
^]