Row Handles Must Be Released Error prevents SSIS package from Importing Data
Hi, I have an SSIS package that has just stopped working. The package is failing on the OLE DB source task. When I execute the data flow task a command prompt briefly flashes and shows that it is running SQLDUMPER.exe. When I edit the OLE DB Source object and click on preview a message pops up saying "Row handles must be released before new ones can be obtained." What's interesting is that the same SSIS package will run fine on our development server but when I transfer it to the production server it receives the error message. What is SQLDumper.exe? What is the cause of failure?
July 7th, 2011 8:17pm

I will start off with explaining in few words what SQLDumper.exe is. This utility is kicked in on an even of a module crash in any of the SQL Server components, SSIS, SSAS, etc. The end result of this tool is a memory dump file/log that typically is used for crash analysis, e.g. a MS Technical staff member may ask you to provide it if needed. There are ways how to analyze such a dump file and it most certainly has something pointing toward the reason for the crash. Now let 's get back to the error at hand. Based on this KB http://support.microsoft.com/kb/257731 it must the version of MDAC on your prod machine. I beleive once you upgrade the MDAC to the latest version the issue will be gone. How to check the MDAC version (just in case you need that): http://support.microsoft.com/kb/301202 (as an aside, I always opt for the checker tool).Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2011 10:34pm

Our servers use Windows DAC version 6.0.6001.18000. I don't think there is a newer version than that is there?
July 11th, 2011 2:41pm

Microsoft Data Access Components (MDAC) 2.8 SP1 is the latest: http://www.microsoft.com/download/en/details.aspx?id=5793Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 11th, 2011 4:05pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics