使用ODBC目标将数据从SQL Server加载到MongoDB [英] Load data from SQL Server to MongoDB using ODBC destination

问题描述

我正在尝试使用SSIS中的ODBC目标将数据从SQL Server表加载到MongoDB集合。显示以下错误。

TITLE：包验证错误

------------------------------

包验证错误

------------------------------
附加信息：

数据流任务错误[ODBC目标[112]]：插入只读列时失败"'嗯??????????????



数据流任务错误[ODBC目的地[112] ]：列元数据验证失败。



数据流任务错误[SSIS.Pipeline]："ODBC目标"验证失败并返回验证状态"VS_ISBROKEN"。



数据流任务错误[SSIS.Pipeline]：一个或多个组件失败验证。



数据流错误任务：任务验证期间出错。



 （Microsoft.DataTransformationServices.VsIntegration）

--------------------------------------------错误结束-------------------------------------------------- ---------------------------------

请帮忙。我该怎么办？正在将数据从MongoDB源（ODBC源）加载到SQL服务器数据库（ADO.NET目标）。

谢谢

解决方案

对于SSIS非关系数据库目标很难处理，这是一个解决方案：

https://rajendersehgal.wordpress.com/2015/07/14/data-migration-between-mssql- nosql的/

Hi,

I am trying to load data from SQL Server table to MongoDB collection using ODBC destination in SSIS. following error is showing.

TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [ODBC Destination [112]]: Failure inserting into the read-only column "'Hum??????????s'".

Error at Data Flow Task [ODBC Destination [112]]: Column metadata validation failed.

Error at Data Flow Task [SSIS.Pipeline]: "ODBC Destination" failed validation and returned validation status "VS_ISBROKEN".

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

 (Microsoft.DataTransformationServices.VsIntegration)

--------------------------------------------End of Error-----------------------------------------------------------------------------------

Please help. what should I do? While it is being loaded data from MongoDB source (ODBC source) to SQL server database (ADO.NET destination).

Thanks

解决方案

For SSIS non-relational DB Destination are difficult to handle, here is a solution: https://rajendersehgal.wordpress.com/2015/07/14/data-migration-between-mssql-nosql/

这篇关于使用ODBC目标将数据从SQL Server加载到MongoDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！