I'm not sure what you thought the QUOTENAME function was going to do, but you're basically using that function against the text of your executed SQL query.   Once you execute...

I'm not sure it's worth the time to do this directly in a query when an SSIS package could make this a LOT easier.   However, the first thing is to...

You don't show what @runtimequery is defined as.   If it's defined as a table, you've got a different problem altogether, as once you go dynamic sql, you lose context and...

And another way:
SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE cdw.FactTable (
  [SID] int NOT NULL,
  Employee_SID int NOT NULL,
  Team_SID int NULL,
  CreationDate int NULL

In general, dimensional data should not need date calculations, as the data feeding the cube should have that kind of thing either "pre-computed" or be an actual field.   However, I'll...

Just to mention that at some point, preserving source data may have value, here's a way to keep it intact, while still accomplishing the same goal.  Note the differences and...

Might there be some other trigger as well?

ftoorabally,

Your last INSERT statement is missing data.   Also, you have a table that has a computed field and you didn't post...

Glad I could help.   Let me re-format your query so it appears more consumable for those reading this thread in the future:
WITH P AS (

    SELECT DISTINCT F.DocumentID,...

I don't think that's how BULK INSERT operates.  My guess is that the whole reason it needs the table in advance is so that it knows exactly what to expect,...