Hello Sam,

Thank you for the response, I agree that it is easier for troubleshooting with the data conversion in.

I've not tested it for performance so I will be looking forward...

Hi,

I've always made the data type changes in the connection manager of the flat file...

This way, it's less work in terms of mapping in the OLE DB Destination Editor (proving...