The problem you have has something to do with recordset you generate to pickup boardno value. First I would try to calculate number of records returned to see if master...

Your problem could be in your Order By statement. I mean in sorting data. If you deal with varchar field then probably you get strange order, but if your BoardNo...

Michael Earl (12/7/2007)

---

tmpCase would not be the name of a temporary table. Temp tables need to start with # or ## (two pound signs is a global temp table).

I...

I had dts installed, before. And I used it very often. But problem appears after installing some hotfixes dealing with integration services. I had also service pack two installed before. I...

the problem resolved on microsoft newsgroup. it was about registering dts.dll.

I will copy two messages from Allan - guy who helped just in case that somebody else have similar...

I have got sql server 2005 standard edition, as I wrote. This does not seem to help.