{"id":3609,"date":"2018-09-05T23:28:47","date_gmt":"2018-09-05T23:28:47","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=3609"},"modified":"2018-09-05T23:28:47","modified_gmt":"2018-09-05T23:28:47","slug":"sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce","title":{"rendered":"SQL &#8211; the area is too big to fit in the column data ( Saleforce )"},"content":{"rendered":"<p>Recently we had an error coming up in SQL &#8220;the area is too big to fit in the column data&#8221;<\/p><p>We had to increase the Column Length Data Type nvarchar(40) to nvarchar(75) of LastName in the Salesforce Source Editor\u00a0\u00a0<\/p><p id=\"lmyGxRE\"><img loading=\"lazy\" decoding=\"async\" width=\"671\" height=\"531\" class=\"alignnone size-full wp-image-3617  img-responsive\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b90664e924a9.png\" alt=\"\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b90664e924a9.png 671w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b90664e924a9-300x237.png 300w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><\/p><p>&nbsp;<\/p><p><a href=\"https:\/\/www.kingswaysoft.com\/products\/ssis-integration-toolkit-for-salesforce\/help-manual\">How to open this<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Recently we had an error coming up in SQL &#8220;the area is too big to fit in the column data&#8221;We had to increase the Column Length Data [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3609","post","type-post","status-publish","format-standard","hentry","category-research"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Recently we had an error coming up in SQL &quot;the area is too big to fit in the column data&quot;We had to increase the Column Length Data Type nvarchar(40) to nvarchar(75) of LastName in the Salesforce Source Editor How to open this\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"paris\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Welcome to Pariswells.com |\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"SQL \u2013 the area is too big to fit in the column data ( Saleforce ) | Welcome to Pariswells.com\" \/>\n\t\t<meta property=\"og:description\" content=\"Recently we had an error coming up in SQL &quot;the area is too big to fit in the column data&quot;We had to increase the Column Length Data Type nvarchar(40) to nvarchar(75) of LastName in the Salesforce Source Editor How to open this\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-09-05T23:28:47+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2018-09-05T23:28:47+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"SQL \u2013 the area is too big to fit in the column data ( Saleforce ) | Welcome to Pariswells.com\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Recently we had an error coming up in SQL &quot;the area is too big to fit in the column data&quot;We had to increase the Column Length Data Type nvarchar(40) to nvarchar(75) of LastName in the Salesforce Source Editor How to open this\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#article\",\"name\":\"SQL \\u2013 the area is too big to fit in the column data ( Saleforce ) | Welcome to Pariswells.com\",\"headline\":\"SQL &#8211; the area is too big to fit in the column data ( Saleforce )\",\"author\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/09\\\/img_5b90664e924a9.png\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce\\\/#articleImage\",\"width\":671,\"height\":531},\"datePublished\":\"2018-09-05T23:28:47+00:00\",\"dateModified\":\"2018-09-05T23:28:47+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#webpage\"},\"articleSection\":\"Research\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pariswells.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research#listItem\",\"name\":\"Research\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research#listItem\",\"position\":2,\"name\":\"Research\",\"item\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#listItem\",\"name\":\"SQL &#8211; the area is too big to fit in the column data ( Saleforce )\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#listItem\",\"position\":3,\"name\":\"SQL &#8211; the area is too big to fit in the column data ( Saleforce )\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/research#listItem\",\"name\":\"Research\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\",\"name\":\"Welcome to Pariswells.com\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris\",\"name\":\"paris\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/93b8ee3f592ac401167f870452bd82d43de80152cd3524e2853403658ada9984?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"paris\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#webpage\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce\",\"name\":\"SQL \\u2013 the area is too big to fit in the column data ( Saleforce ) | Welcome to Pariswells.com\",\"description\":\"Recently we had an error coming up in SQL \\\"the area is too big to fit in the column data\\\"We had to increase the Column Length Data Type nvarchar(40) to nvarchar(75) of LastName in the Salesforce Source Editor How to open this\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/research\\\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"datePublished\":\"2018-09-05T23:28:47+00:00\",\"dateModified\":\"2018-09-05T23:28:47+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/\",\"name\":\"Welcome to Pariswells.com\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"SQL \u2013 the area is too big to fit in the column data ( Saleforce ) | Welcome to Pariswells.com","description":"Recently we had an error coming up in SQL \"the area is too big to fit in the column data\"We had to increase the Column Length Data Type nvarchar(40) to nvarchar(75) of LastName in the Salesforce Source Editor How to open this","canonical_url":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#article","name":"SQL \u2013 the area is too big to fit in the column data ( Saleforce ) | Welcome to Pariswells.com","headline":"SQL &#8211; the area is too big to fit in the column data ( Saleforce )","author":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"publisher":{"@id":"https:\/\/pariswells.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b90664e924a9.png","@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce\/#articleImage","width":671,"height":531},"datePublished":"2018-09-05T23:28:47+00:00","dateModified":"2018-09-05T23:28:47+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#webpage"},"isPartOf":{"@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#webpage"},"articleSection":"Research"},{"@type":"BreadcrumbList","@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/pariswells.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/research#listItem","name":"Research"}},{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/research#listItem","position":2,"name":"Research","item":"https:\/\/pariswells.com\/blog\/category\/research","nextItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#listItem","name":"SQL &#8211; the area is too big to fit in the column data ( Saleforce )"},"previousItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#listItem","position":3,"name":"SQL &#8211; the area is too big to fit in the column data ( Saleforce )","previousItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/research#listItem","name":"Research"}}]},{"@type":"Organization","@id":"https:\/\/pariswells.com\/blog\/#organization","name":"Welcome to Pariswells.com","url":"https:\/\/pariswells.com\/blog\/"},{"@type":"Person","@id":"https:\/\/pariswells.com\/blog\/author\/paris#author","url":"https:\/\/pariswells.com\/blog\/author\/paris","name":"paris","image":{"@type":"ImageObject","@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/93b8ee3f592ac401167f870452bd82d43de80152cd3524e2853403658ada9984?s=96&d=mm&r=g","width":96,"height":96,"caption":"paris"}},{"@type":"WebPage","@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#webpage","url":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce","name":"SQL \u2013 the area is too big to fit in the column data ( Saleforce ) | Welcome to Pariswells.com","description":"Recently we had an error coming up in SQL \"the area is too big to fit in the column data\"We had to increase the Column Length Data Type nvarchar(40) to nvarchar(75) of LastName in the Salesforce Source Editor How to open this","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/pariswells.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce#breadcrumblist"},"author":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"creator":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"datePublished":"2018-09-05T23:28:47+00:00","dateModified":"2018-09-05T23:28:47+00:00"},{"@type":"WebSite","@id":"https:\/\/pariswells.com\/blog\/#website","url":"https:\/\/pariswells.com\/blog\/","name":"Welcome to Pariswells.com","inLanguage":"en-US","publisher":{"@id":"https:\/\/pariswells.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Welcome to Pariswells.com |","og:type":"article","og:title":"SQL \u2013 the area is too big to fit in the column data ( Saleforce ) | Welcome to Pariswells.com","og:description":"Recently we had an error coming up in SQL &quot;the area is too big to fit in the column data&quot;We had to increase the Column Length Data Type nvarchar(40) to nvarchar(75) of LastName in the Salesforce Source Editor How to open this","og:url":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce","article:published_time":"2018-09-05T23:28:47+00:00","article:modified_time":"2018-09-05T23:28:47+00:00","twitter:card":"summary","twitter:title":"SQL \u2013 the area is too big to fit in the column data ( Saleforce ) | Welcome to Pariswells.com","twitter:description":"Recently we had an error coming up in SQL &quot;the area is too big to fit in the column data&quot;We had to increase the Column Length Data Type nvarchar(40) to nvarchar(75) of LastName in the Salesforce Source Editor How to open this"},"aioseo_meta_data":{"post_id":"3609","title":null,"description":null,"keywords":null,"keyphrases":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 05:33:27","updated":"2022-09-22 17:32:17","primary_term":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/pariswells.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/pariswells.com\/blog\/category\/research\" title=\"Research\">Research<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSQL \u2013 the area is too big to fit in the column data ( Saleforce )\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/pariswells.com\/blog"},{"label":"Research","link":"https:\/\/pariswells.com\/blog\/category\/research"},{"label":"SQL &#8211; the area is too big to fit in the column data ( Saleforce )","link":"https:\/\/pariswells.com\/blog\/research\/sql-the-area-is-too-big-to-fit-in-the-column-data-saleforce"}],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=3609"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3609\/revisions"}],"predecessor-version":[{"id":3618,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3609\/revisions\/3618"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=3609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=3609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=3609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}