SSIS error in merge joins

we have developed a application called File converter which uses SSIS to convert different input file formats(flat files, hierarchical files, xml) different output file formats.

File converter is a web application and these SSIS packages are executed via .NET APIs. The crazy error was when we deploy a SSIS package which contains xml sources and merge joins SSIS package execution hangs. But the funny thing is it executes successfully in windows ZP. But it hands on windows 2000.

Customers production environment is windows 2000. We have installed only SSIS service on this machine where File Converter web application is running. After days of trouble shooting we found the cause for the problem. Hurraayyyyy.....

ITS SQL server service pack 2. If you install service pack 2 to SSIS service it does the work.

for more details see http://support.microsoft.com/kb/938049

If you still have the issue install hot fixes for service pack 2 as well.