It's not totally clear to me how you want the data to be broken down.
Can you post a couple of rows of source data (including only a subset...

Your file path appears to start with a single quote and end with a double quote: was that deliberate?

Here is another way:

CREATE FUNCTION dbo.GetSaturday (@Date DATETIME)
RETURNS DATETIME
AS
BEGIN
  RETURN
  (
   SELECT FirstSat = dates.dt
   FROM
     (
       VALUES

Here is some SQL which does this, on the assumption that the value with the highest percentage split is the one to be 'corrected'.

DECLARE @SplitPc TABLE (SplitPercentage DECIMAL(18,...

In this instance, which results would you deem as 'right'? I'm assuming that you want want of those results to round down by 0.01, but which one and what is...

I advise you to check the All Executions report (assuming your package is deployed to SSISDB) to work out the running times for the individual components of the package, in...

Thanks for posting back & glad you got it working.