SSIS sum total file values and load in a status table

Question

Hello Everyone,

This is my first ever SSIS project so far I am happy with it.

But I need to include that file totals summed up like it is done Row cont and create a variable. Then I can load in LoadStatusTb.

Can someone direct instructions or video? I will need it step by step i am very newby.

Thank you so much.

Answer 1

Hi @G A,

I could not get your meaning clearly.

I need to include that file totals summed up like it is done Row cont and create a variable

Do you mean that you want to do row count and then get the variable?

If so, you may check Row Count Transformation in SSIS.

If you already have a table, you may sum the total with sql code and use Execute SQL Task in your package.

Or you may tell us what you have and your expected result for us to do more test.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.