We are using Transfer SQL Server Objects in SSIS Package for copying tables and data from one SQL server database to another database. We have 2 requirements:
1. We need to copy only some tables not all
2. Also for those tables we need to copy only some data depending on user input. for eg. if user selects A bank then we need to copy data only for that bank. Is this possible ? If yes how ? If no what is the other way of doing this ? Is this possible through SSIS ?