The Eval MongoDB command is not working on ZappysSys SSIS PowerPack

Daniel Calbimonte

October 07, 2021 20:34 Updated

Problem

When using the MongoDB ExecuteSQL Task and trying to run the eval command, there is an error. Setting MongoDB Cursor Timeout ( set cursorTimeoutMillis parameter )

The error message is

System.Exception: Command $eval failed: no such command: '$eval'. ---> MongoDB.Driver.MongoCommandException: Command $eval failed: no such command: '$eval'.

Cause

The DB.EVAL was deprecated in MongoDB. According to its website, it was deprecated in version 3.0. See the following link for more information.

db.eval()

Solution

The feature cannot be used in ZS SSIS PowerPack for newer versions of MongoDB. Please contact MongoDB for alternative solutions.

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to support@zappysys.com

https://zappysys.com/support/