Maybe too late now it's end of June. If you are copying all tables (800) then there is a simple SSIS task that copies all tables from one database to...

Hi,

I am just about in the same process. I have 4000 SPs, 700 tables, 400 views etc. Only had issues with SPs. This will be an impossible task without the...

I think this article is a copy from http://www.mssqltips.com/tip.asp?tip=1426, So lets give some credit to that.

It works Ok, but do agree with the others that Excel is not...

I am using a 64 bit server and had the same issue out of the blue. Exactly the same package was failing with the same error message when I remotedesktop...