Why are you still checking - inside the foreach loop - for file existence?  The purpose of the foreach loop is to only process the tasks inside the container *if...

@phil-parkin: do you mean use the "Foreach Loop Container"? Would I then have in the container Expression Tasks or a Script Task?

Yes, that's it.

Configure the 'Collection' node properties as...

You can't delete the history - but you can ignore those backups in your code.  The table 'backupmediafamily' has the column device_type - which will have a value of 2...

This is why having sample data is important.  The data you have doesn't contain that...

Check out this article: https://www.sqlskills.com/blogs/paul/cause-high-duration-async_io_completion-waits/

If this is causing the backups to take longer than they should - you could setup the XE event and gather the same information to provide...

It would help if you provided test data and expected results - but this is what I think you are looking for:

Declare @testTable Table (TestData varchar(100));
 Insert...

Secondary is non-readable. Sole purpose is for fail over and making it the primary.

Source and desitination are SQL Server.

Package is running on Server A which is the primary server.

Yes,...

Have you identified which part of the process is actually causing the delay?  Is it taking 1.5 hours to extract the data from Hadoop - or is it taking 1.5...

Your plan should work fine - there is no reason to do anything with the setup or configuration.  You do want to make sure the secondary is shut down first,...

There are a lot more questions that need to be researched and answered:

1. Are your secondary's set to read-intent or read-only?
2. What is the source and destination for that SSIS...

How are you defining the dataset for the report?

Using Visual Studio (SSDT) - you can right-click on the Dataset and 'Add Calculated Field'.  That brings up the Dataset Properties dialog...

I am not clear on what you mean by 'closed' - data files are not closed.  They may be set to read-only but that is different...

It sounds like you have...

Do you have access to the SQL that is used to get the data from the database?  Or - is this a case where you only have access to execute...

If you take the SAN out of the equation - and only look at it from a management of each instance on that server - you should see that separate...

I would do this in the SQL code - instead of trying to do it in SSRS.  In SQL:

Select Address = replace(OldAddress, '~', char(10))

If it must be...