how i make ssis (sql server integrated services)package to take data from all tables from sql server database to another database but two databases in different server have same structures and schema please help me(ex)
database A:
have 5 tables
1-employee
2-salary
3-sales
4-purchasing
5-purchase order
transfer data from these five tables to another database(B) in another server
database B:
have 5 tables
1-employee
2-salary
3-sales
4-purchasing
5-purchase order