thanks everyone for sharing your thoughts.

I implemented what I need.

Structurally it looks like a RBAR scenario, but, given the situation that, tables being joined T1 and T2 are slim, I...

thank you, I think in my case there is no RBAR

My query extracts from DW and manufactures a summarised aggregate table, which has 1 day information per record, so, max...

thanks.

But, its a bit more programming, involving local-scoped variables, some Queries, some aggregation and a final result.

Can we say something like, SELECT col1, col2, (DECLARE local_variable INT; SET @local_variable =...

Thank you.

I am implementing this in PDW/APS and TRY CATCH is not supported. I can flush a predefined error message from SP and look for that in SSIS, will try

Thanks

Yes Jack, I too had "rows in all tables" option chosen. And had the below error

Sorry for asking this, would you kindly declare 2 indexes and see? Because,...

Hi Jack

I found out the cause, but am yet to figure out the resolution.

My setup is this:

SSIS (Execute SQL Task) ---> Primary Stored Proc with SELECT Statement at...

hi, CTAS is create table as SELECT

thank you

actually there are no intermediate physical tables, the 20 packets of data are result sets of those many queries, which are joined. Even in this scenario, can we have...

thanks.

The 20 tables are actually intermediate 'result sets' each of which are LEFT OUTER JOIN-ed to the other incrementally.

I believe, whether its 20 physical tables or 20 data sets resulted...