I am using SQL Server 2005 Business Intelligence Studio and struggling with returning an integer value from a very simple execute SQL Task. For a very simple test, I wrote the SQL Statement as:

Select 35 As 'TotalRecords'

Then, I specified ResultSet as

ResultName = TotalRecords and
VariableName = User::TotalRecords

When I execute this, the statement is executed but the variable doesn't have the updated value. However, it has the default value that I specified while variable definition.

The return of a date variable works, but integer variable isn't working. The type of User::TotalRecords specified is Int32 in a package scope.

Thanks for any hints