Try $action with OUTPUT.

This is probably too late but how about creating SSRS, creating subscription that never runs and kicking off this subscription from SSIS either to Excel file where formatting created by...

I had to make correction, too. Just want to emphasize that  use
 nvarchar   without lenth  leads to truncation of configured values to 1 symbol. So it is is not...

stevefromOZ (5/9/2016)

---

So what have you tried and what messages do you get back?

it looks like you might need to use the original type and the new type in the unwind...

Thank you for reply.

I got data as I need: all flattened; "header" data added for each nested row.

I just need to get the same result using C# data source...

Thank you for quick respond.

I sure read the...

Hi,

I have exactly the same issue, and the found that solution perfect but it still getting error.

My question is: how could I find the row producing error? I am...

Please keep your old format. The new one is inconvenient.