I'm a fan of setting the compression attribute on the backup directory..

CEWII

I have had this issue and there isn't really a "fix" there is workarounds. The best is to pull copies of the data local, using something like SSIS because...

I understand the whole preferred provider thing, but it shouldn't be a suicide pact.. You might see if the vendor would be interested in you co-locating a SQL Server...

I think the short answer is yes, but I have to admit I think you are in a license violation there.. Unless you also have a SQL 2005 license...

You bet, some of the errors out of SSIS are so opaque it is really hard to see what the problem is. I'm glad you figured it out..

CEWII

I would only keep it on their after you discover the problem if you REALLY need it, but performance is really the only potential issue. If you do a...

This allows it to handle multiple updates at one time (set based operations) and will write a log into a table with the login name (SYSTEM_USER), the hostname (which CAN...

Have you applied the latest service pack? (I know dumb question)

Also have you looked on connect.microsoft.com to see if it is a known issue?

I can definitely see what you...

A quick google search of the txt of that message brings up

User Instance=True in the connection string at:

http://www.bigresource.com/MS_SQL-User-Instance-True-causes-invalid-connection-string-czeUOzHA.html

Some more information here:

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/9cf416a6-cdb0-4b47-a967-b2f431c0f009

Some more here:

http://www.ureader.com/msg/114322.aspx

I am...

what are you using to keep it warm, log shipping? transactional replication? DB Mirroring?

CEWII

Right click on control flow and select Package Configurations. From the Package Configurations Organzier window click add. I prefer to use the XML file but if you want...

First injection proof is not accurate, injection resistant *maybe*. sp_execute is an extended stored procedure doing basically the same thing as EXEC ( 'some sql command' ) or sp_executesql....

I don't see why not, but I would say that the update is a pretty safe script, it is unlikely to fail given the datatypes specified. I would say...

I'm wondering if you have looked at I/O affinity masks?

Also, are you doing the datapulls at the same time, could they be conflicting, does one start before the other(perhaps the...

I'd had a similar problem in the past (couldn't figure out what column was the culprit) and since the messages wouldn't tell me this is what I had to do.

I...