based on all your threads about powerbi and ssis why don't you go read https://www.mssqltips.com/sqlservertip/6333/sql-server-integration-services-power-query-source/ - if it works for some it needs to work for you - you just...

you likely need to grant read/write permissions on the SQL Agent and SQL Instance accounts temp folder to the accounts executing the packages. ACE driver reads/writes files there while processing...

is that proc using a linked server by anychance? that would be a possible reason for that issue (associated with incorrect/invalid credentials for the sql job account)

many times there is no missing index even if you think it should have - the engine determines that and may decide a existing index is good enough to be...

AI bots not around - but there are a few posters that think that getting what ChatGPT gives them as an answer to a question is a good thing. its...

openquery would not allow update of the remote table (which is what the query is doing).

linked servers should really only be used to RETRIEVE data - not to send inserts/updates...

Brandie, while your email may seem legit, many times those posts have a url that is not visible on your email - that would be a possible reason to report...

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