second link - EA from sparks - paid but good.. and does a lot more than that. it is a architect tool.

https://sparxsystems.com/

hum. I had posted 2 links and post was removed.. darn sotware.

first link - it is free (java based) and works well enough - to use with SQL Server a...

agree with Andre .. AI stink - and mention of things that should no longer be used, while supplying some links that really should not be the ones being supplied.

you didn't put the where clause.

if it is indeed saying "where bill_to_address_id  > 0" I would check to see if it is like that to exclude potential negative numbers or...

can you post the full ddl for table ecom.customer_account - including all indexes and FK definitions.

initial though is that you don't have an index on  "ship_to_address_id" and "bill_to_address_id".

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...