You can follow the following steps to get the column values in a variable.

1. Create a package level variable(ex: varCount)

2. Create an Execute SQL Task and set following attributes in the Editor box

ResultSet=Single row and ByPassPrepare=False

3. In the Editor box of Execute SQL Task you can go to ResultSet and putt ResultName=0 and VariableName you can select as varCount.

This way your variable will be populated with the value and you can insert this variable value in a another table.