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

doesn't the hotfix work?

'{000C1B7A-164A-4243-9952-01BC82236EB0}' is not the same as '000C1B7A-164A-4243-9952-01BC82236EB0'

some changes on forums are acceptable - SQL ServerCentral change from old format was a "soft" change and not a "I will never use this again" change.

I used to be...

issue with using a "specific login" is that a sysadmin can execute as any login - so it will still not prevent a DBA from doing it which was the...

you can't - and if you don't trust your dba's not to use it then change the process of accessing that linked server so that it is on a black...

bump for visibility.

and speed differences may be to do with settings on ssms vs vb.net

it really shows a lack of understanding of how SSIS Catalog deployment works, even within VS (which does invoke a command line tool to deploy).

everything can be deployed from CI/CD...

what happens if you move that SP to another container, being executed after the other ones?

and most times its some settings on your sp's or locking between SP's - and...