{"id":634,"date":"2016-06-28T00:55:05","date_gmt":"2016-06-28T00:55:05","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=634"},"modified":"2018-11-14T13:56:48","modified_gmt":"2018-11-14T13:56:48","slug":"insert-multiple-documents-mongodb-using-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/","title":{"rendered":"How to Insert Multiple Documents into MongoDB using SSIS"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2115 alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\" alt=\"\" width=\"88\" height=\"88\" \/>In this post you will learn how to use <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-mongodb-executesql-task\/\" target=\"_blank\" rel=\"noopener\">MongoDB ExecuteSQL Task for SSIS<\/a> to <em>insert multiple documents into MongoDB collection<\/em> using SSIS. This task can be used to perform any DDL or DML operations for MongoDB natively inside SSIS without using any command line utilities. It gives you flexibility and security of SSIS.<\/p>\n<p>&nbsp;<\/p>\n<h2>Step-By-Step &#8211; Insert Multiple Documents into MongoDB Collection using SSIS<\/h2>\n<p>Lets look at how to insert multiple MongoDB documents into<\/p>\n<ol>\n<li>Download SSIS PowerPack from here<\/li>\n<li>Create new SSIS Package<\/li>\n<li>Drag ZS MongoDB ExecuteSQL Task from SSIS Toolbox<\/li>\n<li>Double click task to configure<\/li>\n<li>Create new MongoDB connection by clicking on [New] button next to connection dropdown<\/li>\n<li>Click OK to close connection UI<\/li>\n<li>Now you can enter following Command in MongoDB ExecuteSQL Task to insert multiple documents into MongoDB. If you want to pass json stored inside SSIS variable then use variable placeholders (e.g. {{User::varMyJson}} \u00a0) anywhere inside below command.\n<pre class=\"lang:js decode:true\">{\r\n scope: 'database',\r\n db: 'DemoDB',\r\n command: 'eval',\r\n args: { code: 'db.MyCollection.insert( [ {ID:1,Name:\"AAA\"}, {ID:2,Name:\"BBB\"} ] )' } \r\n}<\/pre>\n<\/li>\n<\/ol>\n<div id=\"attachment_686\" style=\"width: 814px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-insert-multiple-documents-in-mongodb-collection-json.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-686\" class=\"size-full wp-image-686\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-insert-multiple-documents-in-mongodb-collection-json.png\" alt=\"Insert multiple documents in MongoDB Collection (JSON or BSON format)\" width=\"804\" height=\"567\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-insert-multiple-documents-in-mongodb-collection-json.png 804w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/06\/ssis-insert-multiple-documents-in-mongodb-collection-json-300x212.png 300w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/a><p id=\"caption-attachment-686\" class=\"wp-caption-text\">Insert multiple documents in MongoDB Collection (JSON or BSON format)<\/p><\/div>\n<h2>Conclusion<\/h2>\n<p>Using <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-mongodb-executesql-task\/\" target=\"_blank\" rel=\"noopener\">MongoDB ExecuteSQL Task for SSIS<\/a> you can execute ad-hoc MongoDB Shell commands without installing any command line tools. This is totally native SSIS approaching. You can Try <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">SSIS PowerPack for FREE<\/a> to find out many more MongoDB features not discussed in this article.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In this post you will learn how to use MongoDB ExecuteSQL Task for SSIS to insert multiple documents into MongoDB collection using SSIS. This task can be used to perform any DDL or DML operations for MongoDB natively inside SSIS without using any command line utilities. It gives you flexibility and security of SSIS. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2115,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[112],"tags":[121,6,46,82,12,88,4],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Insert Multiple Documents into MongoDB using SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to insert multiple documents into MongoDB using SSIS Task. This MongoDB Execute SQL Task allows you to call any MongoDB Shell Command inside SSIS\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to Insert Multiple Documents into MongoDB using SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to insert multiple documents into MongoDB using SSIS Task. This MongoDB Execute SQL Task allows you to call any MongoDB Shell Command inside SSIS\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-06-28T00:55:05+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2018-11-14T13:56:48+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"88\" \/>\r\n\t<meta property=\"og:image:height\" content=\"88\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/\",\"name\":\"How to Insert Multiple Documents into MongoDB using SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\",\"datePublished\":\"2016-06-28T00:55:05+00:00\",\"dateModified\":\"2018-11-14T13:56:48+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to insert multiple documents into MongoDB using SSIS Task. This MongoDB Execute SQL Task allows you to call any MongoDB Shell Command inside SSIS\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png\",\"width\":88,\"height\":88},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Insert Multiple Documents into MongoDB using SSIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Insert Multiple Documents into MongoDB using SSIS | ZappySys Blog","description":"Learn how to insert multiple documents into MongoDB using SSIS Task. This MongoDB Execute SQL Task allows you to call any MongoDB Shell Command inside SSIS","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/","og_locale":"en_US","og_type":"article","og_title":"How to Insert Multiple Documents into MongoDB using SSIS | ZappySys Blog","og_description":"Learn how to insert multiple documents into MongoDB using SSIS Task. This MongoDB Execute SQL Task allows you to call any MongoDB Shell Command inside SSIS","og_url":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-06-28T00:55:05+00:00","article_modified_time":"2018-11-14T13:56:48+00:00","og_image":[{"width":88,"height":88,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/","url":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/","name":"How to Insert Multiple Documents into MongoDB using SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png","datePublished":"2016-06-28T00:55:05+00:00","dateModified":"2018-11-14T13:56:48+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to insert multiple documents into MongoDB using SSIS Task. This MongoDB Execute SQL Task allows you to call any MongoDB Shell Command inside SSIS","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/mongodb-logo.png","width":88,"height":88},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/insert-multiple-documents-mongodb-using-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Insert Multiple Documents into MongoDB using SSIS"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/634"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=634"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/634\/revisions"}],"predecessor-version":[{"id":5364,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/634\/revisions\/5364"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2115"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}