I have a very simple Execute SQL Task that runs a SELECT statement and brings back a single field.
I have an identical one set up in SSIS 2008, so I really don't think there's anything wrong w/ the query.
But in 2005, when I go to the Result Set page of the task, Add is disabled.
Actually, I have 2 of these so far ... and they worked great in SSIS 2008 ... but i can't map my variables to the result set in either of these in 2005.
Where am I messing up?