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

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