Ssis Moving Data From One Database To Another Database

I am new to SSIS, I want to pull data from one database to another database. for example: I have table tb1 it has 5 rows and by using data flow mask move a copy of the table to ano

Solution 1:

There are two ways to handle this. The easy way is to use bulk load. For this, you start your control flow (not data flow) with a Execute SQL Statement task that will truncate your destination table. So every time you run your package, the destination table will be truncated and you end up loading whatever in the source table. The other approach is to use incremental loading. Here you have many possibilities. Check out this link for more details Best way for incremental load in ssis