Multiple record sets using Execute SQL Task.
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".
June 13th, 2011 4:07am
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
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 4:23am
Hi Sathish,
I need to retrive the result of multiple SELECT queries which can have multiple rows in the SSIS vairable.
June 13th, 2011 4:37am
If you want to pass multiple rows then you must use variable type as object.
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 4:44am
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".
June 13th, 2011 4:48am
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".
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 4:48am
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.
June 13th, 2011 5:00am
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.
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 5:48am
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
June 13th, 2011 11:21am
If you want to pass multiple rows then you must use variable type as object.
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 11:42am
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.
June 13th, 2011 11:56am