I have two databases in same server(sql server 2008). I need to copy only partial data
from some around 20 tables in source and copy it to destination tables using SSIS.
Ex When emp table from source has 1000 rows i only need to copy 100 rows into destination emp table using a filter condition. When using import & export wizard , i am not able to apply filters.