which version of ssis/ssdt are you using?
In 2016 I have ForceExecutionResult for the sequence container; options are 'none', 'success', 'failure', 'completion'.
I'm unsure if this is present in older...

If you set FailPackageOnFailure to True on EST1, I don't think you will get to EST2, as package execution will cease at the point of failure, which is EST1.
If you...

Thanks both for your response.
I guess part of it is down to administrator preference, but so long as one can rationalise their behaviour each method has its pluses and minuses.
And,...

I think it's up to you, and it depends what you are using the UAT environment for?
If you are simply testing any changes or bespoke work, then maybe you...

The number of pages are important. if you have an index that is less than 8 pages, it will be in a mixed extent, and all the reorganizes/rebuilds in the...

I think the number is a percentage?
If you want a clearer indicator try using Brent Ozar's sp_BlitzIndex.

Take the missing index dmv with a pinch of salt though....

I think the benchmark is 1000 pages, if your index is less than this then the script will ignore the index, as previously mentioned. If you are running the reorganise...

First thing I would look at is index usage.
you will need to use dm_db_index_usage_stats for this, and this will show you lookups, reads, writes. A quick search in google...

I don't think that 32GB is going to get you out of trouble, not with 550+ GB database. Can you get anymore memory made available... about 224GB would be a...

I think you may need to provide some more information... like;
what else is on the machine?
is this machine just for sql server?
is there more than one instance on...

i think your problem is in the file path for the parameter in the Execute command... don't you need \\ for each \?

nested CASE statements? First level [ContCode] second level [ContSeqNo, returning [Seq]?

does the sa account still exist?
Does it have a password on the account? is password expiration enabled?