SSIS 包 ODBC 目标:未知列“id”在“字段列表”中;
我正在两个远程服务器之间设置管道,在“目标”工具中选择连接和表,但是单击“映射”时出现以下错误:
令人沮丧的是,没有'ID'源表或目标表上的列...
我正在使用 MySQL ODBC 8.0 Unicode 驱动程序。 我还有其他管道,它们与相同的源服务器和目标服务器配合得非常好。
我尝试重新创建存在此问题的表,但它没有改变任何内容。当我尝试使用该特定表作为 ODBC 源时,也会发生同样的事情...
有什么想法吗?
I am setting up a pipeline between two remote servers, in the Destination tools I choose the connection and the table, but when clicking on Mappings I get the following error:
What is frustrating is that there is no 'id' column either on the source or destination table...
I am using the MySQL ODBC 8.0 Unicode Driver.
I have other pipelines and they work really well with the same Source and destination Servers.
I tried to re-create the tables with this problem but it doesn't change anything. The same thing happens when I try to use that particular table as an ODBC Source...
Any Ideas?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

主要是在表
tech
上有一个触发器,其中使用了id
列。这将不断抛出异常未知列...
。这就是为什么创建一个新表解决了您的问题。有用的链接:
Mainly, there is a trigger on the table
tech
where the columnid
is used. This will keep throwing the exceptionUnknown column ...
. This is why creating a new table solved your issue.Helpful links: