I would write you query like this:

SELECT f.user_id,
       f.email,
       f.start_date,
     ...

I would make sure the user explicitly has permissions to the folder the package is in and any other folders used by the package.

To give permissions to a Windows folder,...

Sounds like the user executing the SSIS package hasn't got permissions on a folder.

Just saw that comment:

drop table if exists testcomp;
go
create table testcomp
(
   ...

If you don't want the code ending with 3 zeros (e.g. 10.C000) then

drop table if exists testcomp;
go
create table testcomp
(
    id int identity(1,1) not null,
...

In SQL Server, the amount of memory used to store the results of a UNION ALL query is dependent on the data types and sizes of the columns being returned,...

This is a deprecated procedure. 😎 "This feature will be removed in a future version of...

EXEC sp_depends 'storedprocedurename'

sp_depends (Transact-SQL) - SQL Server | Microsoft Learn

SELECT TOP(6500)
       ROW_NUMBER() OVER (ORDER...

select top(6500) 
       ROW_NUMBER() OVER (ORDER BY N) ID_INT,
       '10.' + char(ascii('A') + N/1000) +...

You should ORDER BY the entire query in the same order as the ORDER BY in the OVER clause.

SELECT DA.DC,
       DA.WEEK,
...

...

But I'm sure it got further...

But I'm sure it got further than some...

I thought I'd ask my new found tech ChatGPT this question, if there is anyone who hasn't tried it they should, it even knows a bit of...