I've got 2 Project Variables which I use to control wether a package should run or not through the Disable Package Expression

I don't have SSIS in front of me right...

Can you show us the T-SQL which generated the error, along with the data which caused it? Also, what would your ideal solution be? Return NULL instead, with no error?

Not 100% sure about this, but please try it:

DROP TABLE IF EXISTS #temp_usage;

CREATE TABLE #temp_usage
(
    location_id INT
   ,item_id VARCHAR(40)
   ,PERIOD...

Was the 300GB comprised of data which has since been deleted, or just space?

Those backup destinations are local (to the server) drives only, and I'm not sure whether that can be changed.

But you should be able to perform the backup to your network...

Similar to what Grant mentioned, I'd suggest creating a table to help manage the process. Run a process every day to update the table with the...

Similar to what Grant mentioned, I'd suggest creating a table to help manage the process. Run a process every day to update the table with the next day's...

Similar to what Grant mentioned, I'd suggest creating a table to help manage the process. Run a process every day to update the table with the next day's planned messages...

The dumb thing is not asking the question.

The second dumb thing (not applicable here!) is not listening to the answers given by seasoned pros, because you don't like what you...

Many people here won't open non-text attachments, so here is the code, reformatted courtesy of SQL Prompt:

USE Live_PTS;
GO

/****** Object:  StoredProcedure [dbo].[CMS_MakeUP_TIME_11-11-2020]    Script Date:...

Here's a version without requiring UNION:

SELECT tu.location_id
      ,tu.item_id
      ,tu.period
      ,tu.year_for_period
  ...

There's probably a more elegant way of doing this, but this seems to work (I fixed up your data types too)

DROP TABLE IF EXISTS #temp_usage;

CREATE TABLE #temp_usage
(
...

Phil, I don't understand why you think you need the self-join in your code.

It's simple, really: I never seem able to remember that you can update a CTE directly!

Building on Jeff's code:

--===== Create and populate the test able on-the-fly.
DROP TABLE IF EXISTS #TestTable --Makes reruns in SSMS easier.
;

SELECT *
INTO #TestTable
FROM
(
    VALUES
 ...

OK, so ID 3347 should have IDAll = 3 then, shouldn't it?