CODEWITHSUNDEEP
ssis
Jeevan
Jeevan

Reputation: 21

How to keep track of number of rows inserted or updated in a table in SSIS

I am using SSIS for ETL and I need to know how to keep track of the number of records being inserted and updated in a table.

The thing is, in SSIS during the packages is running we will be able to see the number of records processed and no of records being updated or inserted but how to save them to a log file or in any other documents so that we can keep track of it for future references???.

Thanks in advance.

Jeevan kumar

Upvotes: 2

Views: 429

Answers (2)

okrumnow
okrumnow

Reputation: 2416

You may include a RecordCount task in your flow to set a variable with the number of rows passing this point. Later save the variables values into your log file.

Upvotes: 2

Inus C
Inus C

Reputation: 1551

You might want to look at 'triggers in SSMS'. and then use 'output' to log the inserts and updates.

Upvotes: 1

Related Questions