that is absolutely the wrong way to do it.

as you working with vs2022 I would advise you to test the following

in vs build the solution (you said target was 2019),...

when you say job setup to run the package from filesystem - are you using the SQL Agent Integration Step to execute it, or using a command line step with...

see https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/troubleshoot-availability-group-exceeded-rto?view=sql-server-ver15

and

https://dba.stackexchange.com/questions/273498/tempdb-version-store-used-by-db-startup-background-process

it may guide you in the right direction

BOM not worth it - files just should be consistent. throughout.

likely some files are manually created, and others through some utility - this is normally the case when I get...

think you failed to understand what I intended.

when you create a flat file connection manager you should define it's encoding before opening the file so headers get populated correctly. doing...

that looks like a "UTF-8 with BOM" file being read as non unicode.

ensure you use the correct definition when defining the connector - and fix what generates the file not...

have a look at https://www.sqlshack.com/how-to-discover-and-handle-orphaned-database-users-in-sql-server/

and you also need to consider.

• calls using dynamic SQL - will not show up as dependencies
• SQL Agent jobs - both T-SQL on them, and command line/SSIS packages that...

one way - other is to have the file as a valid SQL Server unicode file - there are quirks about it.

drop table if exists Test2 
CREATE...

what does the SQL Logs say about licensing and allocated cores? Could be limited by license applied.

and what is the VM type - some config there may be wrong -...

you can't do that as far as I know - if you do that deny then db_owner is required - but having the list of db's on SSMS does NOT...

if you read my post and the link I gave you it states what you have to do to address that requirement.

if it is partitioned what matters is if it is has the partition operator on the plan or not - if it has then being partitioned is helping the query...

bump.. page bug

best advise is DON'T use SSIS for this.

Load data from one of the db's into a staging (or even tempdb) and do the merge on the SQL server side.

if you...