Using Table variables in SSIS Package

Issue:

When declaring and using T-SQL table variables in SSIS pacakge results in zero rows results.

Solution:
In the query under OLEDB source before actual query execution use "SET NOCOUNT ON".