When I try to create a simple data stream between a flat / OLE DB file in ADO.Net Destination, I get an error message and it deletes my package almost immediately.
[ADO NET Destination [2]] Error: An exception occurred during data entry, message returned by the provider: ERROR [42000] [MySQL] [ODBC 5.2 (a) Driver] [mysqld-5.6.27 -log] You have an error in SQL syntax check the manual that matches your MySQL server version for the correct syntax to use next to "test_etl2" ("id", "phone", "var1", "var2", "var3", "var4", "var5", "name1 "," na "on line 1
[SSIS.Pipeline] Error: SSIS error code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on the component "ADO NET Destination" (2) did not execute with error code 0xC020844B while processing the input "ADO NET Destination Input" (9). The selected component returned an error from the ProcessInput method. The error refers to the component, but the error is fatal and will cause the data flow task to stop working. Prior to this, error messages may appear with additional information about the failure.
[SSIS.Pipeline] Error: SSIS error code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method in Flat File Source returned error code 0xC02020C4. The component returned a failure code when the pipeline engine was called PrimeOutput (). The failure code value is determined by the component, but the error is fatal and the pipeline has stopped executing. Prior to this, error messages may appear with additional information about the failure.
source
share