not me (and many of the prior replies are trolls I believe)

Yes, despite some rather "hacky" solutions, you can't have the x86 and x64 Redistributables installed on the same system.  Ideally, you have the one that matches what's on the...

that wording from the ACE page is just that - words. there are no restrictions within the software as I use it on our servers.

but have a look at https://stackoverflow.com/questions/23523953/empty-excel-file-permissions-issue-ssis-excel-destination-buffers-large-record...

when a user with sysadmin executes the package from the catalog SQL Server will use its own account instead to execute - this will likely bypass some of the security...

if you have the data available within c# then you are doing something wrong.

even if only c# was available, and you have to do that conversion within C# (which you...

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