For testing purposes I created a spreadsheet with 3 columns, Column A, B and C each with the values A B C respectively in ~60,000 rows and used this...
I resolved the issue. The script task concatenates the input columns based on order in which they appear in available input column list and not in the order in which...
I found this article really interesting. I implemented this approach using SSIS 2012 in slightly different way. Instead of storing the hash value in target table, I have computed it...