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?

using a hex editor see what is the true row delimiter.

\r\n is one, but it can also be \r or \n on their own. (you can also try each one...

there is a trick.

create a temp table #dummy - 1 column with the same datatype/size of one of the tables used on your main select.

create a clustered columnstore index on...

create a view over that table without the identity column - then insert into the view instead of the table and see if result is what you wish for.

Ken solution...