Article ID: 938049
Article Last Modified on 6/28/2007
APPLIES TO
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Standard X64 Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
- Microsoft SQL Server 2005 Enterprise X64 Edition
- Microsoft SQL Server 2005 Developer Edition
Bug #: 50001329 (SQL Hotfix)
SYMPTOMS
In Microsoft SQL Server 2005, a SQL Server Integration Services (SSIS) package stops responding (hangs). This problem occurs when the SSIS package contains a data flow task and the data flow task contains one or more MergeJoin transformations.
RESOLUTION
To resolve this problem, install the cumulative update package 2 for SQL Server 2005 Service Pack 2 (build 3175). For more information about the cumulative update package 2 for SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
936305 Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
Keywords: kbpubtypekc kbqfe kbsql2005ssis kbfix kbbug KB938049