Home Forums SQL Server 2005 SQL Server 2005 Integration Services Writing the Execute SQL Task Output to package Variable RE: Writing the Execute SQL Task Output to package Variable
SSIS\SSRS\SSAS
SSCertifiable
Points: 6038
More actions
August 26, 2008 at 11:21 am
#863282
TRY this
"SELECT Count(*) As Count FROM Table A".
Then on the ResultSet , Type Count in the value and map to your Varaiable.
This should work.
thanks