Microsoft KB Archive/938049

= FIX: An SSIS package stops responding when you run the package and the package contains a data flow task that contains one or more MergeJoin transformations in SQL Server 2005 =

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 &quot;Applies to&quot; section.

Keywords: kbpubtypekc kbqfe kbsql2005ssis kbfix kbbug KB938049

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.