copy table to mysql to mysql

Hi all

I want to copy table from mysql to mysql.

Source MYSQL server IP is :172.16.10.50

Destination MYSQL server IP is :172.16.10.152

I used ADO.Net source and Ado.Net Destination.

but at time of execution i faced this error.

[ADO NET Destination [16]] Error: 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 '"status", "status_name", "selectable", "campaign_id", "human_answered", "categor' at line 1

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (16) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (19). 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.

Kindly help me to resolve this issue.

Regards Neha Prajapati

Answers


If you read your error message carefully (or maybe vaguely enough) you can see that the error message states that you have a Syntax Error. What is the query that you are trying to run through SSIS?


Need Your Help

When I LIKE my website none of my og properties are showing up in the news feed. Instead some Facebook default text shows up

facebook debugging facebook-graph-api facebook-like

I got my code to validate with debugger but none of my properties are showing up on the new feed like I want them to. Instead it seems to show a Facebook default text:

JQuery “Click” function isnt working

javascript jquery html

I have a problem with javascript (jquery) and html integration...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.