Hi

Thank you for your compliment

This will encourage me writing more article 🙂

It's good question about performance in large dataset when using recursive group

It will be nice to make some performance...

Hi I am glad you appreciate the article

Thank you for your comment

Have you tried editing in XML code and copy/paste ?

Maybe you have to play with these 2 properties BLOBTempStoragePath and BufferTempStoragePath

Availabe at the Data Flow level

Hi

Can you please post a screenshot of your matrix region and grouping settings if possible ?

Thanks.

Hi

It's a known issue because the data type inside the IIF cannot be qualified

You have to cast the data or use nothing instead of 0

=sum(iif(Fields!Fruit.Value="Apples",Fields!StockEN.Value,nothing))

Hi

Can you post a screenshot of your ssis data flow please ?

Did you configured well the redirection of rows for failure ?

Mohamed

Hi

It will be better to do a data driven subscription and send an excel or any other type of file via email

to your customers

Mohamed

If you add the field BusinessEvent in the existing group "ProductName" ?

Will still it be correct for you ?

Mohamed

Hi

Can you show some sample data and your query if possible ?

Maybe it is not necessary to do a grouping and just need a simple table ordered by productname??

Mohamed

Hi

Did you try to use Script Transformation ?

It is more flexible and you can read the file line by line and do the checking before exporting it to another component

Hi

seems to be possible

check this link

https://msdn.microsoft.com/en-us/library/ms153563.aspx

On the cte keep the contactid field and concatened field only

Then you can use the contactid field of the cte to join the update table a

Normal you then need to add up update command after the cte

bryan.holmstrom (7/30/2015)

---

This code sends an error: I must have something coded wrong?

Msg 156, Level 15, State 1, Line 11

Incorrect syntax near the keyword 'FROM'.

WITH CTE_Concat AS

SELECT lb.ListID, lmb.EntityID,

STUFF((SELECT...