I can't answer this directly because I haven't used SQL Server 2022 however a question which might help other people answer:

You've said that both databases are getting the same data....

I haven't worked with WSFC/AG for a while and I don't have access to a test system but, if I remember correctly, the WSFC cluster provides a reason why it's...

All,

Thank you for all your advice it is very useful. I have attached the execution plans as txt files

• This reply was modified 3 years, 11 months ago by  as_1234. Reason: The site didn't allow me to attach .txt files. So I will try .sqlplan

In addition to the advice above. One thing that might be worth checking, if you haven't done already, is pinging the DNS name and see whether it returns the IP...

Apologises I was thinking that the rows you need to check might all be new or have been updated. As you said it won't pick up existing, unchanged, rows.

Taking a significantly different angle on this and apologises if it's too far outside of the scope of your question but could you use Change Data Capture to identify changed...

Sorry for my mistake. I am having another look at your question and I noticed something:

You said that you need to keep the items marked yellow in your attachment. On...

I think the following might give you the data rows you need?:

declare @sampledata1 table

(

[Date] date ,TC1 varchar(100),Amount_New decimal(10,2)

)
INSERT INTO @sampledata1

([Date]

,[TC1]

,[Amount_New])

VALUES ('2020-11-01','Houses:N-Home',70),

('2020-11-01','Houses:N-KL',80),

('2020-11-01','Default Category: Default Option',90),

('2020-11-01','Houses:NS-Home',22.5),

('2020-11-01','Houses:N-KL',45),

('2020-11-01','Houses:N-GR',22.5),

('2020-12-01','Houses:N-Home',100),

('2020-12-01','Default Category: Default Option',250),

('2020-12-01','Houses:N-Kl',110),

('2020-12-01','Houses:N-Home',24),

('2020-12-01','Houses:N-KL',12),

('2020-12-01','Houses:N-GR',60),

('2020-10-01','Houses:N-BR',24),

('2020-10-01','Houses:N-KL',12),

('2020-10-01','Houses:N-GR',60),

('2020-10-01','Houses:N-BR',24),

('2020-10-01','Default...

People tend to be wary of opening attachments, especially from new users. Can you put the expected result into a post?

It might also help if you can provide test data...

@AlphaTangoWhisley - No problem

All:

The 'failed to lock' runtime error on the file operation was my error. I had the expression for the filenames specified in the source and destination properties...

All,

Thanks for your help. I think I solved the issue by repairing Visual Studio. I thought it was my error rather than an issue with the software but perhaps not.

Since...

• This reply was modified 4 years, 1 month ago by  as_1234. Reason: Editted to include more of the error message

AlphaTangoWhiskey:

Thanks for your help. I don't think the account being used for any proxy or the SQL Server agent will be used when I'm running the package from Visual Studio?...

All,

Thank you for your help. The file is on the SSIS server.

As it looks like I need to rebuild the package I will try that. I won't get time for...

Can you advise which system is generating your alerts? Also is it installed on the same part of the network as the SQL servers?

Do the alerts happen at the same...

I think the information here https://docs.microsoft.com/en-us/windows-server/storage/storage-spaces/understand-quorum#dynamic-quorum-behavior (scroll down to 'two nodes without a witness) will help with your question?

I know that when I ran a cluster on Windows...