Need to update lastupdate field using ssis

deepika omer 1 Reputation point
2022-04-11T07:37:13.223+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,486 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,577 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2022-04-11T08:52:44.037+00:00

    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.

    0 comments No comments