ssis

I have a rather long question regarding the fastest and most accurate way to implement a solution to the following problem (I’ll explain my attempted solution below): I cannot describe the actual data (for business security reasons) so I will use an accurate example. Let’s say that an auto...