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.

Once again in Norway

I am with Anura, dileepa and pathi once again in Norway. This time we work with SPN development team to enhance the current Preator system(Predator is a debt collection system) towards next generation CMS system. Predator's core is written in borland c++ and we are re-engineering its data access layer and business layer to migrate Faircom ISAM to Faircom SQL.

SQL Server Management Studio Reports and Dashboard

Good article to read to check the statistics of MSSQL server using reports and dashboards.

http://www.databasejournal.com/features/mssql/article.php/3743596