if the file is a proper CSV file with the each column value enclosed in double quotes (and inside double quotes proper escaped) then you just need to define the...

the OP sql does NOT have a where clause - its only...

https://www.sqlservercentral.com/forums/topic/sustainable-procurement-best-practices-for-esg-driven-supply-chains-4  looks like AI generated with the sole purpose of being an advertising post of the "Zycus " software/company - and those commenting on it look just like bots created...

Express is free, but no SSIS/SSRS with this. I don't think there are free replacements for them

I might aim for a VM in the cloud I can shut down....

import wizard is 32 bit if you execute immediately - if you schedule to run on server it will execute the package on the server in 64bit mode by default.

VS...

you need to select it - from your image while it is available, it is not selected hence it won't log

by using SSIS you need to also worry about the SSIS execution timeout itself on top of the remote server one

and you also have to worry about the serverwide remote...

use a "group by" on the string_agg sub query

I would change the following

(1 + (COALESCE(Factor,0)/100)) * @PreviousCalculation

to be

(1 + (COALESCE(Factor,0.)/100.)) * @PreviousCalculation -- notice the "dot" on the divide (100.) and on coalesce of factor-

depending on the values...

PowerQuery source works in SSIS - just needs to be done correctly (which you on your thread about it seem to have done all required EXCEPT 1 very important step...

within SSMS

Database ->Storage->Partition Functions

Database ->Storage->Partition Schemes

yes you can copy them to another location and process them on a different server.

you read them in SQL Server as any other .xel file (or through powershell - google it)

folders like this should be owned by a group containing the domain administrators - and then these can grant required permissions to  local administrators and other accounts as needed

starting to get annoyed with this user https://www.sqlservercentral.com/forums/user/srinivasdba19

been posting scripts (and not his own for sure) as reply to a whole bunch of threads - some of the scripts are...