I'm using SSIS with the Office 12 Access Database engine to do this export; I've tried EPPLUS and that works well for small exports, but the large data volume here causes consistent timeouts.
I can use the DTSWIZARD package, except where the columns to be exported are large - VARCHAR(8000). These give sizing errors e.g. DTS.Pipeline reports a 4000 character restriction on the output - even when I edit to this length in the SQL creating the output.
Any tips on handling these large columns, please?