• This functionality appears completely broken in SSIS 2014.

    You can generate files in the IDE or by command line but cannot do so using an SQL Agent Job.

    With 32 but Access Drivers Installed,

    With Execute as 32 bit specified in the step or even using a command line step that explicitly calls the 32 bit dtexec. It simply returns the same error messages as a command line calling the 64 bit one.

    An absolute total waste of my time.