SSIS 2008 Variables 101

Sometimes it is easy to get confused with Parameterized Stored Procedures in Execute SQL Task in SSIS specially when dealing with multiple variables. In SQL Server 2000 DTS, executing multi-parameterized Stored Procedure is less confusing.