SSIS工具数据流来实现sqlserver的表的数据导入到mysql中的某个表,但是会报个错误:
[ADO NET Destination [2]] 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 '"SO_NUMBER") VALUES (p1); INSERT INTO XQB_TEST_bak20230616_1 ("SO_NUMBER") VALUE' at line 1
我的ADO NET Destination能test connection成功,而且足够权限,并且我目标源并没有写sql语句,为啥给我返回个sql错误我是没相同的
有没有实现过这个功能的SSIS相关操作的提供下帮助,谢谢~