NO Steve, the problem is one field is IsSortSeqNo and another one named like ISSortSeqNo...

If you noticed, the second letter of the field name is upper and lower case.

So SSIS has problem in mapping when execute with different databases. I know we can change the filed name in database itself, but I am just curious, whether there is any way to check through scripts ? So that I would use the script in Execute SQL task...