I am using an SCD component in my SSIS platform. I have set all my columns as changing attributes(Type 1) while setting it up.
The data from the source table to the destination table seems to look the same. But still, I see the records being updated considering it as a changed record. I observe there are spaces in the data (both trailing and leading spaces). Will SCD consider this as a change and update the table?
If yes, How can this be rectified? How can we solve this issue?
I tried implementing ltrim and rtrim to my source query but seems not to be working. Any suggestion would be of great help.
using Visual Studio 2019