Just a couple of amendments to my last post:

1. Tables can also have datatypes defined as NUMBER without precision and scale specified (defaults used - which then results in SSIS...

With my recent experience of querying Oracle for Numeric fields, I've noted that SSIS defaults a field's output type with an OLEDB query as Unicode string of length 38 (the...