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.

I don't think that you want [] around the filepath do you?

I received this question with supporting documentation about an open case with MS. At the time I needed some questions and posted it ,...

select sum( case when sub2 = 0 then sub1 else sub2 end)

from ...