Hi All, I have a stored procedure which has two SELECT queries. How can i store the result of these queries in the SSIS vairables using Execute SQL Task. In the result set section of the Execute SQL Task i had added two vairabls which will store the record sets results but i am getting error saying There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset".

Hi Prashant If you are using the result set as singlerow you can pass only one value to the variable. Refer this http://msdn.microsoft.com/en-us/library/ms141689.aspx http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx

Hi Sathish, I need to retrive the result of multiple SELECT queries which can have multiple rows in the SSIS vairable.

If you want to pass multiple rows then you must use variable type as object.

Yes, i had created two variables of type Object which will stored the two SELECT queries result but i execute it i get the below error There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset".

Yes, i had created two variables of type Object which will store the two SELECT queries result of stored procedure but when i execute it i get the below error There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset".

Use Separate Execute Sql Task for each variable.Because the Result name must '0' for passing value to the variables.You cannot have the same result name for both the variables.

If the two results have to be separated out to two separate objects , then two execute sql tasks are inevitable. If the two select statements are placed in the same execute sql task and one result set is used all the results are combined into one obejct variable.Happy to help! Thanks. Regards and good Wishes, Deepak.

Hi Prashant If you are using the result set as singlerow you can pass only one value to the variable. Refer this http://msdn.microsoft.com/en-us/library/ms141689.aspx http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx

If you want to pass multiple rows then you must use variable type as object.

Use Separate Execute Sql Task for each variable.Because the Result name must '0' for passing value to the variables.You cannot have the same result name for both the variables.