Thanks Jack. I've tried manipulating the "externa'" and "Output/Input" columns in my source and destination objects within the Data Flow. However, I always get an error. I am probably doing something wrong because I am brand new to SSIS. Can you tell me where I can input the conversion expression (DT_BYTES,5)? I am using a SQL query as my source in the OLE DB Source. I've tried using CAST and Convert but I there aren't any SQL data types that seem compatible with DT_BYTES.
DT_BYTES is the destination. The source is DT_STR.
Thanks. RH