136 How to move 3 days older files to a folder in SSIS

Hi sir Thank you for this videos, i really appreciate that effort , Please Sir add the subtitles it's important to non English Students

Hi Akhil,
There is id value 1 from table x and id value 2 in y table .we need to merge these two tables and update the id value as 3

Great Video. Keep going.
I have a scenario. Any help with this scenario would be great help. The data is generally related to tickets.
The data comes from CSV on daily basis which is dumped in SQL Server. There is a derived column to add the data loading date as an additional column to differentiate yesterday’s data from today. GETDATE () function.
The requirement is to maintain two tables in SQL Database.
The tickets are received daily out of which some might not get resolved and gets carried forwarded to next day. The new tickets (inflow) and the unresolved from previous day is received as CSV which is dumped into Table 1. Need to create Table 2 where only inflows are stored. Compare today’s data with the previous day and if duplicate found remove them and only store the new tickets (inflow).
Note: Each ticket has a unique ID.
Anything possible with Multicast? Eagerly waiting for the solution.