Just an FYI - I have found that shrinking in smaller amounts will speed things up considerably. No more than 2GB at a time seemed to be optimum for our...

Thank you. I missed it completely!

you might also try sp_helprotect.

Thank you all for your suggestions. We sized the archive database for 2 years of data and the initial load will be for 1 year. I completely blanked out on...

You might try creating an sql script that will format your selection and use it with OSQL and an output file.

nope - no errors at all.

You may want to check this out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

Another option might be to save the packages as VB files (.bas, it's an option in the Save As) and compile them into executables.

Yet another way:

use Northwind

go

Select top 2 rownum = identity(int,1,1),

           productid, quantity

into #tmp

from [order details]

order by quantity desc

select * from #tmp

where rownum = 2

drop table #tmp

The maximum value that an integer data type can contain is 2,147,483,647. Try using a bigint data type.

Thank you for the input. I just finished reading todays' article on DTS Logging and I think using SQL-DMO would be the way to go. Now I just need to...

The packages I need to update with new connection information already exist in an SQL Server. Currently, I  open the package in designer and modify the connections. I would like...

Just one installation - Advanced Server on C. The SQL binaries are currently on E.

Unfortunately, I don't know. You would have to contact support for your disk controller manufacturer and find out  from them. It's done at the controller level.

This very much like the 605 error. Microsoft advised us to turn off read caching completely. Generally, you will need to turn the write cache up to 100% in order...