The issue seemed to be originating from the default datatype in the Unicode choice of the SSIS package wizard.

For details please look here 

Thank you Brendon. I have saved them as packages, have run them directly from the SSIS and still the same issue.

What I will do is to export the package from ...

Cheers Brian!

Thanks for all the lovely input. Truth be told we created our tool for documentation and compliance purposes, but it has become so bloody good (apologies for the modesty...

I think you nailed the biggest issue here.

It is the compartmentalization!

You as a DBA you say, I have my kit (chosen by someone else), I have the code (written by...

Hi Brian,

Thank you for the great response! Look, I think you just specified how one can built a decent benchmarking mechanism for actual DB performance.

I did not claim that the...

• This reply was modified 3 years, 8 months ago by  dimitrisv.

Thank you Scott. Indeed I completely agree. It is almost an impossible task. However, there ought to be studies about such costs.

I was told that IBM research had produced such...