SSIS 2005 Execute SQL Task Editor can't map result set

Daniel Wilson
Daniel Wilson used Ask the Experts™
on
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?

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Just make sure you have the ResultSet property set to Single Row. If you do, then we can go from there.

Author

Commented:
Aha, that was it!  ResultSet was set to None!

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial