Try setting Delay Validation to true for the connection manager. That way you don't need to worry about the initial value.

Create a new connection manager for the logging. See if that makes a difference.

Cannot say I am seen that before.

How are you creating two transactions? is the logging using the same connection manager as the ones in the transaction?

How about sharing the error?

If you use SQL in a variable and supply that to the source, it should work.

Post the error and we may be able to help/

Weird, You have it on fast load and a redirect after the destination. This used to give an error as you could not do that. I see now it does...

Are you using a SQL destination? If so, is the package running on the same machine as the SQL instance you are trying to connect to? SQL Server Destination MUST...

You can use the pivot or unpivot component.

If you can translate the error to English, we might be able to help

Yes it can. Open a solution in BIDS and add existing package. Choose SQL Server location. This will open the package from the server even though your client machine is...

What is a multi valued parameter? You can only pass one parameter, that may include multi values.

select * From dbo.MyFunc('1, 2, 3, 4') would be one param.

Can you qualify that? "will always fail after it reaches around 30%"

A Nas is a network link so contradicts your statement.

We used to backup 8TB to tape (Robot) which took...

So long as you can connect to the remove server via SQL, you can create it locally, and save it to MSDB on the remote server. To edit it, open...

Why not setup asynchronous mirroring? There will no no impact on your prod box because it's async, and your destination server will always be up to date.

Adding a PK to...

My first criteria would be load.

Identify the busiest DBs and decide how many machines you have to spread them over.

Then, take the medium DBs and spread them. One or two...

Sorry, forgot to mention that indexed view / space thing.

What you say is true as well. At first glance, a query is a...