{"id":1423,"date":"2017-01-20T16:48:42","date_gmt":"2017-01-20T11:18:42","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1423"},"modified":"2017-01-20T16:49:30","modified_gmt":"2017-01-20T11:19:30","slug":"data-type-error-in-execute-sql-task","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1423","title":{"rendered":"Data type error in Execute SQL Task"},"content":{"rendered":"<p><b>Error:<\/b><\/p>\n<p>Here we have come up with one more error from SSIS project recently practiced by student of\u00a0<a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI training<\/a>. This error has occurred in the Execute SQL Task component present inside \u201cForeach Loop\u201d Container as it shows redcross mark on the component as shown in the image down below.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12.jpg\" rel=\"attachment wp-att-1424\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1424\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12.jpg\" alt=\"1\" width=\"627\" height=\"405\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12-300x194.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>Now let see the exact error under Progress tab which says that the parameter cannot convert from String to Int32 data type.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-12.jpg\" rel=\"attachment wp-att-1425\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1425\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-12.jpg\" alt=\"2\" width=\"627\" height=\"210\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-12.jpg 627w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/2-12-300x100.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/a><\/p>\n<p>Now in order to see where the issue has been caused open Execute SQL Task Editor Component under \u201cParameter Mapping\u201d tab of Execute SQL Task as shown in the image down below.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-11.jpg\" rel=\"attachment wp-att-1426\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1426\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-11.jpg\" alt=\"3\" width=\"628\" height=\"283\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-11.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/3-11-300x135.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>Here we see that everything is in Int32 data type and we know that EmpName and EmpAdd cannot be integers but they should be strings.<\/p>\n<p><b>Solution:<\/b><\/p>\n<p>The solution was given by the trainer of\u00a0<a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI training<\/a> to the student suggesting to just change data type for EmpName and EmpAdd from \u201cInt32\u201d to \u201cString\u201d under Parameter Mapping tab.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-11.jpg\" rel=\"attachment wp-att-1427\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1427\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-11.jpg\" alt=\"4\" width=\"628\" height=\"321\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-11.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/4-11-300x153.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<p>After applying changes to data type now re-run the package. You will see all components running successfully with green mark as shown below.<\/p>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-9.jpg\" rel=\"attachment wp-att-1429\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1429\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-9.jpg\" alt=\"5\" width=\"628\" height=\"329\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-9.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2017\/01\/5-9-300x157.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error: Here we have come up with one more error from SSIS project recently practiced by student of\u00a0MSBI training. This error has occurred in the Execute SQL Task component present inside \u201cForeach Loop\u201d Container as it shows redcross mark on &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1423\">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":[167,168,139,166,109,108,120],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data type error in Execute SQL Task - 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=1423\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data type error in Execute SQL Task - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"Error: Here we have come up with one more error from SSIS project recently practiced by student of\u00a0MSBI training. This error has occurred in the Execute SQL Task component present inside \u201cForeach Loop\u201d Container as it shows redcross mark on &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1423\" \/>\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-20T11:18:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-01-20T11:19:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12.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=1423#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1423#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1423\",\"name\":\"Data type error in Execute SQL Task - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1423#primaryimage\"},\"datePublished\":\"2017-01-20T11:18:42+00:00\",\"dateModified\":\"2017-01-20T11:19:30+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1423#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1423\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1423#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data type error in Execute SQL Task\"}]},{\"@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":"Data type error in Execute SQL Task - 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=1423","og_locale":"en_US","og_type":"article","og_title":"Data type error in Execute SQL Task - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"Error: Here we have come up with one more error from SSIS project recently practiced by student of\u00a0MSBI training. This error has occurred in the Execute SQL Task component present inside \u201cForeach Loop\u201d Container as it shows redcross mark on &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1423","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2017-01-20T11:18:42+00:00","article_modified_time":"2017-01-20T11:19:30+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12.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=1423#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2017\/01\/1-12.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1423#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1423","name":"Data type error in Execute SQL Task - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1423#primaryimage"},"datePublished":"2017-01-20T11:18:42+00:00","dateModified":"2017-01-20T11:19:30+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1423#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1423"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1423#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"Data type error in Execute SQL Task"}]},{"@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\/1423"}],"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=1423"}],"version-history":[{"count":1,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1423\/revisions"}],"predecessor-version":[{"id":1431,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1423\/revisions\/1431"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}