Going to give it a try with.  
.Net Web Client
Seems the SSIS objects are flaky.

We're executing it using SSMS - connecting to the sis server A and running the package from the SSISDB.  
Note, I've since tried to run the package on the server...

yes

Have you considered using BIML for this task?

I have stats from San provider for the 1200MB - I appreciate these are based on 100% random access and are theoretical, even so I expect more than 700MB.

We're seeing a ceiling on reads of around 700MB/s  kind of expect 1200MB/s+ with 64KB blocks.   We have fibrechannel connections to the network.  These aren't being filled so I think...

If there were Kerberos issues this would prevent connections to be made to Portal / Data sources, right?   We have reports that run fine.  Some reports time out due to...

Yep I agree - I was more hoping for best practice but on reflection I guess there are trade offs all over the place.

It's okay, I found SQL Browser is setting a dynamic port.  Need to use 2382 as it's a named instance.

Thanks Grant - that makes sense.   One use case I have in my mind is to run a daily clone:  Prod to Test/Sandbox (for ad-hoc user querys).   Reluctant to have...

I remember trying to set Emergency Mode but it wouldn't let me do this.  I can understand SQL kind of had pants down and wanted to pull them up before...

Hopefully the developers have used a standard naming convention to allow you to see keys easily.   SQL Prompt is a helpful tool too as it help you write the ON...

The database had (Suspect) after the db name in SSMS.  After re-start it went into Recovery Pending State and I could see in the logs the recovery was underway.
Due...

Depending on the size of the fact load and source  you may able to break it up to load parts - you may find this is quicker that forcing it...