Its known bug in SQl Server 2000.Evene one hotfix is there for solving this problem.this generally occurs when you are using look up queries in your package.this can be fixed...