I'm studying SSIS and I created a flow to import the records of a file (source) into a SQL table (destination).
The fields in the source don't match the columns in the destination:
in the former, I have the fields "active subscriptions" and "inactive subscriptions", whereas in the destination I only have "number of subscriptions" (they are all numerical values).
I want to sum the values of "active subscriptions" and "inactive subscriptions" and merge them into the column "subscription" in the destination.
First, I suppose I should use an expression to sum the values of "active subscriptions" and "inactive subscription", but which control should I use to retrieve those values?
What I have tried:
I figured out I should use an expression to sum the values of the two fields of the source file.
I saw a tutorial that makes use of user variables within the context of an expression, therefore I figured out I should have two variables to store the values of "active" and "inactive subscriptions" and two controls associated with them which retrieve those values, but I'm not sure whether it is correct and how to achieve it (specifically, which control I should use).
If it's not correct, can you please explain to me which would be the right approach to this?