In my OLE DB Source to Flat File Destination Data Flow, I have quite a few columns and it's excruciating to manually set each one to decimal with a scale of 4.
I tried adjusting my SQL code in the OLE DB Source to CAST to decimal(14,4) to see if SSIS would pick that up in Suggest Types, but it likes single-byte signed integer. I don't see any option to set default column DataTypes. Is there another way - either by adjusting my SQL code, or within SSIS options - to get all of my columns to decimal, scale 4?