I have a sql task which creates a temporary table and selects values from the temporary table. I want these values in a object variable. But I'm getting this error when I'm trying to execute the task. "No disconnected record set is available for the specified SQL statement.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

This is due to the record set in an Execute SQL task being set to full result set and the task not returning a dataset. You state that you create a temporary table and select values. What are you populating the table with? Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Hey thanks jeff, I found a solution for this I have used a CTE instead of temporary table. Wonder it worked. Seriously I don't know why. I appeciate your help.

No problem. Glad you found a solution.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker