Hello,

Thanks for your answers but alas, I still have big troubles trying to import this huge CSV file.
I'm very new with SSIS.
I tried to make a...

Hi Joe,
Where is this  [ Edit Mapping ] button ?
I'm not at work but if I well remember, this button if for output data source, not input.
That's the...

Whaooo!
I feel so stupid. :o(
I should sleep more or change my glasses.
It's now obvious ! :o)
One colleague had a look and did not see anything...

The 2nd screenshot seems to prove it's actually a char(160) in the data, doesn't it ?

Hi all,

Thanks for all your investigations and suggestions. 🙂

Since I've replaced XML conversions (necessary with former "SQL Server 2008" but useless and costly with 2014 release) with standard CAST, all...

Hi!

Finally, I had the answer from a guy that knows the history of the databases and associated scripts.

XML...

Nobody can see images I insert in my post or just Luis ???

Hello Hugo,

Hugo Kornelis (11/23/2016)

Well, I can tell with 100% certainty that there are at least two differences:

1. The statistics on the data in UAT are different from those on PROD,...

In fact, I'm not the author of the script of this view and I actually don't know why XML was used for conversion.

There is perhaps a good reason that I...

Thanks ! 🙂

Sorry, it's a "copy/paste" from the horrible editor of "SQL Server 2014 Management Studio".

Did not find any way to make it respect indentation. 🙁

Steph.

Hello all,

Thanks for your answers and the nice metaphor from Hugo. 😉

But I still don't understand why there is a difference of behavior between optimizer on UAT and PROD.

I'm...