MongoDB doesn’t have SQL Like query language so sometime you may feel odd…But has native JSON like Query language (Sorry SQL Guys. To see full detail about possible query syntax see online help. In our previous post we discussed how to query/load MongoDB data (Insert, Update, Delete, Upsert). In this post you will see how to query MongoDB by date (or ISODate) using SSIS MongoDB Source. ZappySys provides high performance drag and drop connectors for MongoDB Integration. 7 SQL Like Query Language using SSIS PowerPack.
4 Remember to suffix “Z” in your date format to indicate its UTC date.3 How to Query MongoDB ISODate Attribute.
0 kommentar(er)
