Most likely it will continue for the next 5-6 years. SQL Server 7 is still supported (although that's about to end) and it was released on 99.

What does the process do? Perhaps the data has changed. Be sure you run update statistics on the tables involved, also check dbcc showcontig for fragmentation. If it's drastically changed,...

If you have a steady enough workload, i.e., not too many ad hoc queries, then this will work. It typically hasn't been an issue with my systems, but we have...

Or you just give them rights to select from the view or underlying table with granting insert, update, or delete.

What is the package doing when it is hanging? Try running it interactively from the designer to see.

The waittype means that the OLEDB conenction is waiting on something.

Be sure that this login has rights to connect to SQL Server. Test logging in yourself as this account.

The issue with having slow IO and causing the page latches is something you'd fix with hardware changes. You are accumulating latches (lightweight locks) because it is taking too long...

In SQL Server 2000, you can have collation set at the column level, so each column could be different. You can set a default for the db and change it...

http://www.sqlservercentral.com/columnists/sjones/whodoyouhire.asp

It boots sqlsrvr.exe in the windows priority against other applications. It might get you slightly better performance, but if there are other processes on the box that might need resources,...

http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

I've heard good things about Protegrity, but hanve't used it.

http://www.protegrity.com/products1.html

Does it do this if you run it interactively? Can you double click the failed item and get an error?

Most likely it's a data problem. Try changing the first and...

I believe 6.5 only had Std and Enterprise editions. If select @@version doesn't return it, I'd look through the registry keys (HKLM/Software/MS/SQL Server) for it or properties of the server...

Must be some bug somewhere. I'll take a look.