Can yo find out  Active Directory account is not locked out and the password has not expired?.

Secondly, you may use proxy account to run the job, make sure the account...

Try to download from this link:

https://learn.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver16

Few details about AG Group Setup/Listener

https://www.sqlservercentral.com/articles/sql-server-always-on-availability-group-ag-listener-step-by-step-guide

Can you provide more details about the Instance and Store procedure ?

-- Is the instance part of AG Group or Standalone?

-- Is stored procedure switching to different linked server based...

Forum members here will not download files because of possible infections/viruses.

Provide DDL with some sample data with required output.

deleted the duplicate post.

Your constraint should be something like below, drop the existing one on the table and create it as the following.

ADD CONSTRAINT CHK_Dates CHECK 
(
   ...

Go and access filesystem through command prompt and check under program files/program files(x86) if the software is really installed.

Windows core interface will be little different.

When are you using gpg4win,  inside the SSIS package or as a different step to encrypt the file?

If the process is inside the package, my assumption, it looks like during ...

Grant ssis_admin role to the user and give it a try.

You can find additional details about SSIS DB here:

https://learn.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver16

Enable RPC and RPC Out properties of the linked server and ensure that the remote user login and password are correct.

Eric:

Check this link if this helps, may be at a granular level:

https://www.mssqltips.com/sqlservertip/3153/managing-ssis-security-with-database-roles/

what happens if you deny EXECUTE OBJECTS?

I am not aware of any setting. check how many transactions are not committed/open or taking long time using the below query? Is tempdb located on faster drive? Based on...

1) Attach a new hard disk or an empty LUN to the server.

2) Take the SQL Backup first (Full, differential and Trans), move the backup files it to a safer...

Try this:

SELECT Item_id, sum(qty)
FROM [#TempSOR_mb]
WHERE subitem_id not in (203,299)
group by Item_id

The WHERE clause acts as a filter to exclude subitem_id.