SSIS is tricky - specially if executed through the SSIS Catalog (which should be the case... executing from Visual Studio should not be done except during development).

have a look at...

firewall, wrong dns (do a ping on that box to see ip vs what you get on your pc), wrong instance name (is it a named instance? if so "\"...

look at https://www.microsoft.com/en-us/licensing/product-licensing/client-access-license#tab-overview

if it is a small organization and all the users on that organization are going to need access to the SQL Server (directly or indirectly) then buy device...

on top of setting up kerberos delegation - this now needs to be "constrained delegation" - unconstrained will no longer work due to security changes

then why not supply an example of a file that you fail to process along with the SSIS packaged you built. This has been asked for in your original threads...

articles in question above were

database-architecture-considerations-for-implementing-content-moderation-services

and

revolutionizing-efficiency-the-power-of-custom-automation-software-development

ok.. so I posted a test here - it worked fine.

then I changed it to link to 2 articles posted on forums - and the post got removed.

am I (and...

also assumes that that process runs in the local pc (which has the license for Office).

So not enterprise/production ready really, but that may be what is required for your client.

you need to install the integration services component for you VS version.

for 2019 is on https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

I'm not going to comment on whether to remove db from HA or not - others with more experience on that will likely comment. But if you have a good...

as soon as you put anything outside the Database itself, you loose all referencing capabilities.

SQL Server Agent jobs in my opinion the worst option, specially if they go with 1...

AI and promotion of company - should be removed

never seen it not work - but batch mode NOT always the best option.

Always test before and after with real production data volumes.

no way - while a clustered index on the desired columns will in many cases output the data on that order, there are cases where it won't.

if you have issues...

and working well with what solution?