Lets map the values returned by query to SSIS variables
Final Output :
Just to display the values of SSIS variable I used Script Task. Provided the variables to Script task and wrote below script to display.
Provide the variables as shown below and then hit Edit Script
Write this code in Main
MessageBox.Show("Records Inserted ::"+Dts.Variables["User::VarInsertCnt"].Value.ToString() +" Records Updated::"+Dts.Variables["User::VarUpdateCnt"].Value.ToString());