My column had it's integrity constraints violated by a value
This was the line that appeared after the error log entry on SSIS saying "unknown error":
The value violated the integrity constraints for the column.For some reason it did tickle me. Simple things simple minds.