I get it - thank you for the update.

Jeffrey,

I have fully read your comments - multiple times 🙂

I think I have been schooled - in a nice way. I have spent the last hour studying both tables,...

SQL Server will use all memory that is available - up to the configured max memory for the instance.  Is there some issue with SQL Server using this memory?

Have you seen these:

http://tech-trainer.info/extend-alwayson-sql-cluster-in-azure-step-by-step/

https://docs.microsoft.com/en-us/previous-versions/azure/virtual-machines/windows/sqlclassic/virtual-machines-windows-classic-sql-onprem-availability

I have not set this up myself - but will be looking to do something similar once we are able to upgrade to SQL Server 2022.

What is the purpose and goal for this secondary instance?  What issues are you trying to resolve with this secondary instance?

If the goal is to just have a read-only secondary...

Hi Jeffrey,

Thanks for getting in touch.

"Many questions have been asked for additional information, table definitions, sample data *and expected results*."

I have provided all of the above - tbh, some...

It was code that was provided to me to fix an issue.

Its hard to determine the number of rows that will be matched.

The thing that is troubling me is...

We have an issue when we apply new OS patches and for some reason SSIS catalog jobs fail.

I was researching on it as well. These are some initial steps..let...

Just piling on with @ratbak

Every object in your queries should be qualified with the schema owner. If for no other reason, it reduces, in ever so tiny an amount,...

I believe the previous answers are the better options - but if you are stuck with doing this in SSIS and need to query the header data, then query for...

If accessing the same instance...

Why would you want to do that?  The catalog is a much better method of managing SSIS than using package deployment and a file system.

DNS would be the best solution - that way you don't have to update connection strings when you failover to the DR/alternate site.  Upon failover the aliases would have to...

First thing - if the file was previously being sent in a format with CRLF and it changed to LF for record terminator, then I would be asking the sender...

There is no reason for the sub-query.  Just use that query in the insert statement:

Insert Into Planning
Select T0.ID,T1.SID,[dbo].[Planning](T1.Id,T0.SId) as Status
from BDetails T0
cross join SDetails T1

Better yet -...