SSIS MongoDB ExecuteSQL Task

MongoDB ExecuteSQL Task can be used to execute ad-hoc commands for MongoDB (e.g. DDL statements such as Create/Drop collection, DML statements such as Insert, Update, Delete or Run JavaScript and shell commands.)

Features

  • Intuitive user interface with many examples makes MongoDB learning super easy and fast
  • Support for executing DDL statements such as Create/Drop table
  • Support for executing DML statements such as Select/Insert/Update/Delete
  • Support for saving RawResult (e.g. JSON response) into SSIS variable
  • Support for saving SingleValue from response such as count or size from getStats function response.
  • Support for saving FullResultset as ADO.net dataset (e.g. select * from mycollection) can be stored as ADO.net recordset (can be used with ForEachLoop container task for looping).

Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

Insert document into MongoDB

MongoDB execute command - insert JSON document into MongoDB

 

Get table list as ADO.net recordset variable (Used with ForEachLoop)

MongoDB get table list as ADO.net recordset variable (Used with ForEachLoop)

 

Call server side MongoDB JavaScript functions

MongoDB call server side JavaScript

 

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012 or 2014
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This