Need to update lastupdate field using ssis

Question

Hi ,

I have a SSIS scenario.

1) I need to load data from base table to base table only based on max date.

2) Need to check matching and not matching records based on some parameter with other two tables.
if record match then read next record if not then update last update field in base table.

Apart from lookup how to achieve this

Answer 1

Hi @deepika omer ,

1)You could use an aggregate with a max for the date column.

ssis-aggregate-data-flow-transformation.html

If you are using SQL Server database table, you could use a group by query in your source to choose the max date.

2) In this scenario, lookup component should be the best choice.

Or you may use excute sql task to use sql command to meet your need.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.