I'm just being stupid. I KNOW you can't have a diff without a full backup. Here is a test I did:

Something's very strange going on.

On this particular server I have...

See this: http://social.msdn.microsoft.com/Forums/en/transactsql/thread/cf3a9b8c-90f2-410c-978b-c1d995f7e0f9

I have resolved the problem, see my edited reply above.

Thanks for your help.

I opened the package in NotePad++ but when I search for the variable it's not there!

This is just typical SSIS bull$h!t.

I've resolved the issue!

I found a loose Execute SQL Task...

Yea thanks. I've been trying to view the XML but Visual Studio seems to crash. It's a large package with many components.

I will keep trying and see what happens.

Why do you need to do it row by row? What's the logic...

Could this be considred a good hint to add some covering indexes?

I'm using the IP.

I'm using SSMS, Connect -> Database Engine -> then using SQL Server Authentication to connect. Was just confused that I could use 3 IPs and still connect to the same...

Thanks George, makes sense now.

Found my answer which I already knew but I was just being stubborn!

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.connectionmanager.connectionstring.aspx

It says:

The format and contents of the connection string depend on the data provider, the data source, and...

pdanes (10/17/2012)

You think, then, that such a cascaded full/differential/transaction approach makes sense, even given the situation I've described? If so, may I ask for your reasoning on the matter? It...

You need to work out the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) for each of your databases.

Both of these will help you work out the appropriate recovery...

Scary DBA?! http://www.scarydba.com/

Yes, I see what you mean. It's going to take more time to set these up but in terms of security then it's much better than granting the SQL Agent...