MA2005


Hi

I have a Sql execute task, which has a select query which returns back a column value(always one value). I need to store that into a user variable. Do i add a resultset type, and if so which one Also do i add a new parameter in the param mapping window, with direction of output Please let me know, since I need to store the resultset value to a user variable. Thanks.





Re: SQL Execute Task


Re: SQL Execute Task

Phil Brammer

ResultSet = Single Row

No parameters unless you need to pass them into your query.







Re: SQL Execute Task

Hery Susanto WR

sorry, I didn't read Ravi's reply..it helped me
thanks all

---------------------------------------------------------------------------------------------
Hi Phill,
I need to pass parameters into my query, I've created parameter in Parameter Mapping, but I didn't know how to pass them into query.
Can you tell me

thanks in advance