Article ID: 924016 - View products that this article applies to.
Bug #: 898 (SQL Hotfix)
Consider the following scenario. In Microsoft SQL Server 2005, you try to run a SQL Server Integration Services (SSIS) package. The SSIS package transfers data between two instances of SQL Server 2005. In this scenario, you may receive an access violation error message. When this problem occurs, the Microsoft Windows Application log contains an event that documents the system error message. The system error message resembles the following:
Note This problem occurs when Lookup transformations that are in the SSIS package are executed in parallel. This problem does not occur when Lookup transformations that are in the SSIS package are executed sequentially.
DTExec.EXE - Application Error The exception unknown software exception (0x40000015) occurred in the application at location 0x7ee8bd9e.
This problem occurs when Lookup transformations from multiple data flow tasks share the same cache area. Lookup transformations may share the same cache area when the text in the SQLCommand property of one Lookup transformation that isin a data flow task is the same as the text in the SQLCommand property of a Lookup transformation that is in another data flow task.
To work around this problem, use one of the following workarounds:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
For more information about the MaxConcurrentExecutables property, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.package.maxconcurrentexecutables.aspxFor more information about the Lookup transformation in SSIS, visit the following MSDN Web site:
Article ID: 924016 - Last Review: September 17, 2011 - Revision: 3.0
Contact us for more help
Connect with Answer Desk for expert help.