{"id":1350,"date":"2017-01-11T14:08:59","date_gmt":"2017-01-11T08:38:59","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1350"},"modified":"2017-01-11T14:08:59","modified_gmt":"2017-01-11T08:38:59","slug":"pivot-component-in-ssis-sql-server-integration-services","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1350","title":{"rendered":"Pivot component in SSIS (SQL Server Integration Services)"},"content":{"rendered":"<p>Pivot component is Data Flow component available under Transformation of SSIS(SQL Server Integration Services). Configuring it improperly may cause difficulties in working with component. We at\u00a0<a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">Mumbai MSBI training<\/a> give enough learning and practice for many such SSIS component.<\/p>\n<h3>Error:<\/h3>\n<p>The error occurred during the pivoting process of the records. The records in the SQL are as follows,<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7.jpg\" rel=\"attachment wp-att-1356\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1356\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7.jpg\" alt=\"1\" width=\"452\" height=\"299\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7.jpg 452w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7-300x198.jpg 300w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/a><\/p>\n<p>Here we can see that the records are not sorted and also it is not properly grouped.<\/p>\n<p>Therefore the error has caused on Pivot component,<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-7.jpg\" rel=\"attachment wp-att-1357\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1357\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-7.jpg\" alt=\"2\" width=\"395\" height=\"289\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-7.jpg 395w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-7-300x219.jpg 300w\" sizes=\"(max-width: 395px) 100vw, 395px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-7.jpg\" rel=\"attachment wp-att-1358\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1358\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-7.jpg\" alt=\"3\" width=\"627\" height=\"200\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-7.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-7-300x96.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>The error says that the value violated the integrity constraints of the column and here constraints means that the values in the columns are not sorted.<\/p>\n<h3>Solution:<\/h3>\n<p>The solution is to add a new component named \u201cSort\u201d and in this component define on which column field we have to do sorting.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-6.jpg\" rel=\"attachment wp-att-1359\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1359\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-6.jpg\" alt=\"4\" width=\"628\" height=\"237\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-6.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-6-300x113.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>Connect output of \u201cOLE DB Source\u201d component as input to \u201cSort\u201d component and then connect output of \u201cSort\u201d component as input to \u201cPivot\u201d component.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-5.jpg\" rel=\"attachment wp-att-1360\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1360\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-5.jpg\" alt=\"5\" width=\"628\" height=\"377\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-5.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-5-300x180.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>Now again re-configure the Pivot component by double clicking the component and opening its Editor window<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-3.jpg\" rel=\"attachment wp-att-1361\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1361\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-3.jpg\" alt=\"6\" width=\"354\" height=\"321\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-3.jpg 354w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/6-3-300x272.jpg 300w\" sizes=\"(max-width: 354px) 100vw, 354px\" \/><\/a><\/p>\n<p>Once Editor is open check mark on field \u201cMonth\u201d in Available Input Columns and select \u201cSort Type\u201d as \u201cascending\u201d.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/7-3.jpg\" rel=\"attachment wp-att-1362\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1362\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/7-3.jpg\" alt=\"7\" width=\"628\" height=\"565\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/7-3.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/7-3-300x270.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>After configuring the component run the package by clicking on \u201cStart\u201d option available under Menu bar.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/8-1.jpg\" rel=\"attachment wp-att-1363\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1363\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/8-1.jpg\" alt=\"8\" width=\"628\" height=\"319\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/8-1.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/8-1-300x152.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>The result is shown here after adding and configuring the Sort Component.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/9.jpg\" rel=\"attachment wp-att-1364\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1364\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/9.jpg\" alt=\"9\" width=\"525\" height=\"203\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/9.jpg 525w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/9-300x116.jpg 300w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/a><\/p>\n<p>Explaining each steps and getting practical\u2019s done from the candidate is key benefit of attending\u00a0<a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI training<\/a>. With this tradition established among the candidates will help them to remember the topic learned.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pivot component is Data Flow component available under Transformation of SSIS(SQL Server Integration Services). Configuring it improperly may cause difficulties in working with component. We at\u00a0Mumbai MSBI training give enough learning and practice for many such SSIS component. Error: The &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1350\">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":[155,14,156,154,109,108,120],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pivot component in SSIS (SQL Server Integration Services) - 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=1350\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot component in SSIS (SQL Server Integration Services) - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"Pivot component is Data Flow component available under Transformation of SSIS(SQL Server Integration Services). Configuring it improperly may cause difficulties in working with component. We at\u00a0Mumbai MSBI training give enough learning and practice for many such SSIS component. Error: The &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1350\" \/>\n<meta property=\"og:site_name\" content=\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-11T08:38:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7.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=1350#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1350#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1350\",\"name\":\"Pivot component in SSIS (SQL Server Integration Services) - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1350#primaryimage\"},\"datePublished\":\"2017-01-11T08:38:59+00:00\",\"dateModified\":\"2017-01-11T08:38:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1350#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1350\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1350#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pivot component in SSIS (SQL Server Integration Services)\"}]},{\"@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":"Pivot component in SSIS (SQL Server Integration Services) - 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=1350","og_locale":"en_US","og_type":"article","og_title":"Pivot component in SSIS (SQL Server Integration Services) - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"Pivot component is Data Flow component available under Transformation of SSIS(SQL Server Integration Services). Configuring it improperly may cause difficulties in working with component. We at\u00a0Mumbai MSBI training give enough learning and practice for many such SSIS component. Error: The &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1350","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2017-01-11T08:38:59+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7.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=1350#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-7.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1350#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1350","name":"Pivot component in SSIS (SQL Server Integration Services) - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1350#primaryimage"},"datePublished":"2017-01-11T08:38:59+00:00","dateModified":"2017-01-11T08:38:59+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1350#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1350"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1350#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"Pivot component in SSIS (SQL Server Integration Services)"}]},{"@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\/1350"}],"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=1350"}],"version-history":[{"count":1,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1350\/revisions"}],"predecessor-version":[{"id":1365,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1350\/revisions\/1365"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}