-- Sample only: stage source extract into a raw table
IF OBJECT_ID('tempdb..#src') IS NOT NULL DROP TABLE #src;

SELECT
    CAST(SourceId AS INT) AS SourceId,
    CAST(SourceName AS NVARCHAR(200)) AS SourceName,
    CAST(SourceUpdatedUtc AS DATETIME2(0)) AS SourceUpdatedUtc
INTO #src
FROM dbo.SourceExtract;

INSERT INTO dbo.Stg_SourceRaw (SourceId, SourceName, SourceUpdatedUtc, LoadDtmUtc)
SELECT s.SourceId, s.SourceName, s.SourceUpdatedUtc, SYSUTCDATETIME()
FROM #src s;