Other solutions for same task(you may create a function out of this):

1:

declare

@pString VARCHAR(7999)='asdfasdf-asddf- -wer-we',

@pDelimiter CHAR(1) = '-'

;with a(N) as

(

select 1

union all

select...

Actually you can do it quite simple - for example you are using a stored procedure to load data from SQL Server or other RDBMS - LoadData_sp.

And this procedure has...

In my practice I never seen the situation when jobs are always finished successfully.

Besides, FACT tables are a subject to read - not only ETL insert is involved.

Sometimes you may...

No sense adding PK to FACT if strategy is only INSERT(APPEND).

Will just slow down the load.