July 6, 2012 at 7:18 am
Hi All,
i am trying to create a ssis package -2008
with sql as source and mysql as destination and i am getting the following error
i am using ado.net source and destination and mysql connector 5.01
the following error message is what i get
please help me
SSIS package "Test-corseinfo.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "student_id" (646) on output "ADO NET Source Output" (635) and component "ADO NET Source" (630) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning.
Error: 0xC020844B at Data Flow Task, ADO NET Destination [124]: An exception has occurred during data insertion, the message returned from the provider is: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]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 '"subhash" ("STUD_Forename_1", "STUD_Surname", "Course", "STEN_Start_Date", "STEN' at line 1
Error: 0xC0047022 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (124) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (127). 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.
Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "ADO NET Destination" (124)" wrote 0 rows.
Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: Data Flow Task
Warning: 0x80019002 at Test-corseinfo: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) 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 "Test-corseinfo.dtsx" finished: Failure.
thanks,
subash
July 6, 2012 at 12:15 pm
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 '"subhash" ("STUD_Forename_1", "STUD_Surname", "Course", "STEN_Start_Date", "STEN' at line 1
This part from the error message looks to be the cause.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply