{"id":1160,"date":"2016-12-22T17:30:35","date_gmt":"2016-12-22T12:00:35","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1160"},"modified":"2016-12-22T17:30:35","modified_gmt":"2016-12-22T12:00:35","slug":"use-csv-filecomma-separatedin-extraction-process-of-ssis-msbi","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1160","title":{"rendered":"Use CSV filecomma separatedin extraction process of SSIS, MSBI"},"content":{"rendered":"<p>Hey learner\u2019s let us get acquainted with one more error which a candidate of <a href=\"http:\/\/stepbystepschools.net\/?page_id=868\" target=\"_blank\">Mumbai in MSBI training<\/a>. Below explained is the scenario which caused error and resolution given to it.<\/p>\n<h3>Error:<\/h3>\n<p>Now while doing the ETL process we are using a \u201cCSV\u201d file. We are taking the CSV file and then doing the Extraction Transformation and Loading process on it. The ideal CSV file looks like this,<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1.jpg\" rel=\"attachment wp-att-1161\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1161\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1.jpg\" alt=\"1\" width=\"452\" height=\"165\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1.jpg 452w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1-300x110.jpg 300w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/a><\/p>\n<p>But while doing this a trainee from Mumbai MSBI Training session conducted by SBSS group, faced an error like this<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-1.jpg\" rel=\"attachment wp-att-1162\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1162\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-1.jpg\" alt=\"2\" width=\"611\" height=\"384\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-1.jpg 611w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-1-300x189.jpg 300w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-1.jpg\" rel=\"attachment wp-att-1163\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1163\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-1.jpg\" alt=\"3\" width=\"693\" height=\"342\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-1.jpg 693w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-1-300x148.jpg 300w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/><\/a><\/p>\n<h3>Solution:<\/h3>\n<p>The solution for this error was simple, as CSV file type was used its default format is that all the data in it should be separated comma (,). The trainee had missed to put some comma<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-1.jpg\" rel=\"attachment wp-att-1164\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1164\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-1.jpg\" alt=\"4\" width=\"433\" height=\"137\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-1.jpg 433w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-1-300x95.jpg 300w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/a><\/p>\n<p>So always remember the data should be separated with comma (,) in a CSV file, like this:<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-1.jpg\" rel=\"attachment wp-att-1165\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1165\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-1.jpg\" alt=\"5\" width=\"423\" height=\"176\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-1.jpg 423w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/5-1-300x125.jpg 300w\" sizes=\"(max-width: 423px) 100vw, 423px\" \/><\/a><\/p>\n<p>After doing this when the program is executed it gives us the proper output.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6.jpg\" rel=\"attachment wp-att-1166\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1166\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6.jpg\" alt=\"6\" width=\"617\" height=\"361\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6.jpg 617w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/6-300x176.jpg 300w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7.jpg\" rel=\"attachment wp-att-1167\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1167\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7.jpg\" alt=\"7\" width=\"564\" height=\"504\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7.jpg 564w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/7-300x268.jpg 300w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/><\/a><\/p>\n<p>Interested in attending upcoming\u00a0<a href=\"http:\/\/stepbystepschools.net\/?page_id=868\" target=\"_blank\">Mumbai training on MSBI<\/a> topic visit this link and get to know completely in detail about two days training information.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hey learner\u2019s let us get acquainted with one more error which a candidate of Mumbai in MSBI training. Below explained is the scenario which caused error and resolution given to it. Error: Now while doing the ETL process we are &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1160\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[106],"tags":[115,112,114,107,109,108,110],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Use CSV filecomma separatedin extraction process of SSIS, MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stepbystepschools.net\/?p=1160\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use CSV filecomma separatedin extraction process of SSIS, MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"Hey learner\u2019s let us get acquainted with one more error which a candidate of Mumbai in MSBI training. Below explained is the scenario which caused error and resolution given to it. Error: Now while doing the ETL process we are &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1160\" \/>\n<meta property=\"og:site_name\" content=\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-22T12:00:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"StepByStepSchoolsSupport\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\",\"url\":\"https:\/\/www.stepbystepschools.net\/\",\"name\":\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"description\":\"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stepbystepschools.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1160#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1160#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1160\",\"name\":\"Use CSV filecomma separatedin extraction process of SSIS, MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1160#primaryimage\"},\"datePublished\":\"2016-12-22T12:00:35+00:00\",\"dateModified\":\"2016-12-22T12:00:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1160#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1160\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1160#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use CSV filecomma separatedin extraction process of SSIS, MSBI\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\",\"name\":\"StepByStepSchoolsSupport\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"caption\":\"StepByStepSchoolsSupport\"},\"url\":\"https:\/\/www.stepbystepschools.net\/?author=40\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Use CSV filecomma separatedin extraction process of SSIS, MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","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:\/\/www.stepbystepschools.net\/?p=1160","og_locale":"en_US","og_type":"article","og_title":"Use CSV filecomma separatedin extraction process of SSIS, MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"Hey learner\u2019s let us get acquainted with one more error which a candidate of Mumbai in MSBI training. Below explained is the scenario which caused error and resolution given to it. Error: Now while doing the ETL process we are &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1160","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2016-12-22T12:00:35+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"StepByStepSchoolsSupport","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.stepbystepschools.net\/#website","url":"https:\/\/www.stepbystepschools.net\/","name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","description":"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stepbystepschools.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/?p=1160#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-1.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1160#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1160","name":"Use CSV filecomma separatedin extraction process of SSIS, MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1160#primaryimage"},"datePublished":"2016-12-22T12:00:35+00:00","dateModified":"2016-12-22T12:00:35+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1160#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1160"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1160#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"Use CSV filecomma separatedin extraction process of SSIS, MSBI"}]},{"@type":"Person","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655","name":"StepByStepSchoolsSupport","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","caption":"StepByStepSchoolsSupport"},"url":"https:\/\/www.stepbystepschools.net\/?author=40"}]}},"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1160"}],"collection":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1160"}],"version-history":[{"count":1,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1160\/revisions"}],"predecessor-version":[{"id":1168,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1160\/revisions\/1168"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}