That's the thing... I have no p1 in the UI.
There's an "Execute SQL Task" that executes "set sql_mode='ANSI'"
Then it goes into the "Data Flow Task". In the "Data Flow Task" There's two items. ADO Source and ADO Destination.
The source is MSSQL2005, the destination is mySQL.
That's it.
If I remove the ANSI SQL then this is the error.
Error: 0xC020844B at Export <table>, ADO NET Destination [465]: An exception has occurred during data insertion, the message returned from the provider is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"<col 1>", "<col 2>", "<col 3>", "<col 4>", "<col 5>", "<col 6>", "<col 7>", "<col 8>' at line 1
Error: 0xC0047022 at Export <table>, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (465) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (468). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.