We are in the process of upgrading from 2014 to 2019 so both are using the same cardinality estimator. We are experiencing almost across the board a 6% to 10%...

Thanks. I went with your workaround suggestion, in the end. Changing the order of the parameters didn't help.

Thinking about it, the default can't be refreshed all the time otherwise it...

I also had an edit appear to hang validating output to a Fact table. What I worked out was that at the same time, I was altering the table to...

Agree with others struggling with the XML Source step in the data flow. I think that for the sake of us new to XML, it would have been nice to...

I had to do this recently and my workaround was to have 1 row of formatted data retained under the column headings in my template but hidden.

However, that was a...