SSIS is a straight connection to the view using OLEDB destination fast load, , check constraints off, fire triggers option.

I checkes the meta data on the ssis side, it doesn't...

If I do this, where ColumnA and ColumnB is NOT NULL

insert into [extract].[vw_MERGE_SourceTable]

(RowID, ColumnA, ColumnB,InsertDate, UpdateDate,RowAction)

values

(100, NULL, NULL, NULL, GETDATE(), GETDATE(),'D')

The trigger on vw_MERGE_SourceTable deletes the...

The query itself is 300 lines long, consisting of 13 different tables (five of which are partitioned on month_end) - my main reason for not posting it is the size...

I think we're misunderstanding each other.

I currently have two issues.

Before loading an additional month:

1.

Currently, the non-clustered indexes being recommended by Database Engine Tuning Advisor do not include MONTH_END - If...

Thanks - b is how I currently have it.

The clustered index on all the tables is currently only on MONTH_END.

The tables that join don't all necessarily join on the...

All around the same principal, below is another account_nbr.

I have the following calculations:

1.) [Months Since GT0 greater than 0] (up until latest month)

2.) [Months Since GT0 greater than 1]...

@chris-2 Morris-439714 - thanks - that's putting me on the right track... I'll see if I can work with this, its not quite as simpple as my calculation,...

For Better Assistance

CREATE TABLE #mytable

(

ACCOUNT_NBR CHAR(19),

...

Yeah - not quite that easy.

The Column GT0 represents payments missed, so when the value is 1, that months payment was missed.

I'm trying to retrieve the count of the...