B_Pati
asked on
SSIS :: Copy Data from source to Destination Using SSIS
Hi Experts,
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi ,
I had to use Slowly changing Dimension transformation Control to complete my task. The link you provided helped me as a starting point.
I had to use Slowly changing Dimension transformation Control to complete my task. The link you provided helped me as a starting point.
Thanks for the feedback. I fail to see how the SCD component would help you with your request, in fact I never use that component because it has some annoying limitations. But okay, if you got it to work for your scenario, all the better!
Also see https://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=26