Exporting empty tables from SQL tables to csv format

I have followed the instructions on and I'm getting the following error:

SSIS package "C:\source\repos\CSV02\CSV02\SO_51195870.dtsx" starting. Information: 0x4004300A at DFT Generate Export, SSIS.Pipeline: Validation phase is beginning. Error: 0xC0202009 at DFT Generate Export, OLESRC Query [9]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Syntax error, permission violation, or other nonspecific error". Error: 0xC004706B at DFT Generate Export, SSIS.Pipeline: "OLESRC Query" failed validation and returned validation status "VS_ISBROKEN". Error: 0xC004700C at DFT Generate Export, SSIS.Pipeline: One or more component failed validation. Error: 0xC0024107 at DFT Generate Export: There were errors during task validation. Warning: 0x80019002 at FELC Shred Results: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. Warning: 0x80019002 at SO_51195870: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "C:\source\repos\CSV02\CSV02\SO_51195870.dtsx" finished: Failure.