{"id":1172,"date":"2016-12-24T18:00:17","date_gmt":"2016-12-24T12:30:17","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1172"},"modified":"2016-12-24T18:40:51","modified_gmt":"2016-12-24T13:10:51","slug":"incorrect-selection-of-ssis-component-in-msbi","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1172","title":{"rendered":"Incorrect selection of SSIS component in MSBI"},"content":{"rendered":"<p>While creating SSIS project during <a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI Mumbai training<\/a> a fresher trainee got stuck up with following error.<\/p>\n<h3>Error:<\/h3>\n<p>Lab is of SSIS project and whileusing Conditional split this is the error which was faced by a trainee conducted at SBSS. The screensnap of the error is as follows:<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2.jpg\" rel=\"attachment wp-att-1173\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1173\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2.jpg\" alt=\"1\" width=\"628\" height=\"299\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2-300x143.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-2.jpg\" rel=\"attachment wp-att-1174\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1174\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-2.jpg\" alt=\"2\" width=\"467\" height=\"184\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-2.jpg 467w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/2-2-300x118.jpg 300w\" sizes=\"(max-width: 467px) 100vw, 467px\" \/><\/a><\/p>\n<h3>Solution:<\/h3>\n<p>The solution to the problem is that the trainee had taken the \u2018Flat File Source\u2019 Component instead of \u2018Flat File Destination\u2019. When the error data or any kind of data to be loaded always use \u2018Flat File Destination\u2019 or other components from \u201cOther Destinations\u201d option in SSIS Toolbox, because loading of data should always be in destination file not in the source file.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-2.jpg\" rel=\"attachment wp-att-1175\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1175\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-2.jpg\" alt=\"3\" width=\"627\" height=\"216\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-2.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/3-2-300x103.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>After taking the \u2018Flat Destination File\u2019,<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-2.jpg\" rel=\"attachment wp-att-1176\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1176\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-2.jpg\" alt=\"4\" width=\"627\" height=\"246\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-2.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/4-2-300x118.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>Being very new to the MSBI and if you want to learn it practically then have a look at complete syllabus and upcoming batch date of <a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI Mumbai training.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While creating SSIS project during MSBI Mumbai training a fresher trainee got stuck up with following error. Error: Lab is of SSIS project and whileusing Conditional split this is the error which was faced by a trainee conducted at SBSS. &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1172\">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":[121,107,109,108,119,120],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Incorrect selection of SSIS component in 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=1172\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Incorrect selection of SSIS component in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"While creating SSIS project during MSBI Mumbai training a fresher trainee got stuck up with following error. Error: Lab is of SSIS project and whileusing Conditional split this is the error which was faced by a trainee conducted at SBSS. &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1172\" \/>\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-24T12:30:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-12-24T13:10:51+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2.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=1172#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1172#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1172\",\"name\":\"Incorrect selection of SSIS component in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1172#primaryimage\"},\"datePublished\":\"2016-12-24T12:30:17+00:00\",\"dateModified\":\"2016-12-24T13:10:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1172#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1172\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1172#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Incorrect selection of SSIS component in 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":"Incorrect selection of SSIS component in 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=1172","og_locale":"en_US","og_type":"article","og_title":"Incorrect selection of SSIS component in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"While creating SSIS project during MSBI Mumbai training a fresher trainee got stuck up with following error. Error: Lab is of SSIS project and whileusing Conditional split this is the error which was faced by a trainee conducted at SBSS. &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1172","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2016-12-24T12:30:17+00:00","article_modified_time":"2016-12-24T13:10:51+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2.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=1172#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-2.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1172#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1172","name":"Incorrect selection of SSIS component in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1172#primaryimage"},"datePublished":"2016-12-24T12:30:17+00:00","dateModified":"2016-12-24T13:10:51+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1172#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1172"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1172#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"Incorrect selection of SSIS component in 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\/1172"}],"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=1172"}],"version-history":[{"count":3,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1172\/revisions"}],"predecessor-version":[{"id":1197,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1172\/revisions\/1197"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}