Use of the WITH clause in SQL Command SSIS OLEDB Source

If you try to use the WITH clause in a SQL Command of an OLE DB Source in a Data Flow of Integration Services, you might receive the error ‘Statement(s) could not be prepared’.

Solution: put a semicolon (;) just before the WITH keyword.