{"id":10667,"date":"2023-10-26T22:07:51","date_gmt":"2023-10-26T22:07:51","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=10667"},"modified":"2023-11-03T07:51:37","modified_gmt":"2023-11-03T07:51:37","slug":"tips-ssis-send-html-email-task","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/","title":{"rendered":"Some tips for the SSIS Send HTML Email Task"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

Sending an email with HTML can be difficult if you want to be stylish. In this article, we will show you some examples with CSS that will help you send better emails. We will use the HTML Email Task. You can check the article here<\/a><\/p>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n
    \r\n \t
  1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
  4. (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>\n

    First, drag and drop the HTML Email Task.\u00a0Next, let’s work on formatting and combining rows. This will help create more flexible tables within the email. After making these changes, you can use the preview button to check the result.<\/p>\n

    Note: Make sure the <style> is the first thing you use in the body of the email.<\/strong><\/p>\n

    \n
    <style>\r\n\u00a0 \u00a0 table {\r\nborder-collapse: collapse;\r\nwidth: 100%;\r\nborder: 1px solid green;\r\n}\r\n\r\n\u00a0 \u00a0 th,\r\n\u00a0 \u00a0 td {\r\nborder: 1px solid blue;\r\npadding: 5px;\r\n}\r\n\r\n\u00a0 \u00a0 th {\r\nbackground-color: orange;\r\n}\r\n\r\n\u00a0 \u00a0 td.resultado {\r\nfont-weight: bold;\r\n}\r\n<\/style>\r\n\r\n<table border=\"1\">\r\n\u00a0 \u00a0 <tr>\r\n\u00a0 \u00a0 \u00a0 \u00a0 <th>Header 1<\/th>\r\n\u00a0 \u00a0 \u00a0 \u00a0 <th>Header 2<\/th>\r\n\u00a0 \u00a0 <\/tr>\r\n\u00a0 \u00a0 <tr>\r\n\u00a0 \u00a0 \u00a0 \u00a0 <td rowspan=\"2\">Combined Cell<\/td>\r\n\u00a0 \u00a0 \u00a0 \u00a0 <td>Row 1, Cell 2<\/td>\r\n\u00a0 \u00a0 <\/tr>\r\n\u00a0 \u00a0 <tr>\r\n\u00a0 \u00a0 \u00a0 \u00a0 <td>Row 2, Cell 2<\/td>\r\n\u00a0 \u00a0 <\/tr>\r\n<\/table><\/pre>\n<\/div>\n
    \"HTML<\/a>
    Example for the tables<\/p><\/div>\n
    In the following example, we’ll demonstrate how to modify the email’s body and text, including changing colors, size, and font styles for specific text elements.<\/p>\n
    <style>\r\nbody {\r\nfont-family: Arial, sans-serif; \/* Change font *\/\r\nbackground-color: #bdb5f0; \/* Change background color *\/\r\n}\r\n\r\nh1 {\r\ncolor: #5bb258; \/* Change color for 'h1' elements*\/\r\n}\r\n\r\np {\r\ncolor: #da0e0e; \/* Change color and line height for 'p' elements*\/\r\nline-height: 1.5;\r\n}\r\n\r\n.highlight {\r\nbackground-color: yellow; \/* highlight a section *\/\r\n}\r\n\r\n#important {\r\nfont-weight: bold; \/* bold only id = important*\/\r\n}\r\na.visited-link {\r\ncolor: blue;\r\n\/* initial color *\/\r\ntext-decoration: none;\r\n\/* removes decoration *\/\r\n}\r\n\r\n\/* clicked url *\/\r\na.visited-link:visited {\r\ncolor: red;\r\n\/* it will change the color from the URL *\/\r\n}\r\n<\/style>\r\n\r\n<h1>HTML with CSS Examples<\/h1>\r\n<p>This is a simple HTML document with some CSS styling examples.<\/p>\r\n<p>This paragraph has a <span class=\"highlight\">highlighted background<\/span>.<\/p>\r\n<p id=\"important\">This paragraph is important.<\/p>\r\n<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" class=\"visited-link\">Zappysys SSIS<\/a>\r\n<a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/\" class=\"visited-link\">Zappysys ODBC<\/a><\/pre>\n
    \"HTML<\/a>
    Example with font, color and background<\/p><\/div>\n
    After implementing these changes, this is how your email will appear. Please note that this is just an example, and you have various options to further customize your email.<\/p>\n
    Conclusion<\/strong><\/h2>\n
    In conclusion, CSS can transform your emails into more visually appealing and effective communication tools. For more information on using CSS in HTML files, you can explore this resource here<\/a>. With CSS, you can create even more impressive email examples<\/p>\n","protected":false},"excerpt":{"rendered":"
    Introduction Sending an email with HTML can be difficult if you want to be stylish. In this article, we will show you some examples with CSS that will help you send better emails. We will use the HTML Email Task. You can check the article here First, drag and drop the HTML Email Task.\u00a0Next, let’s […]<\/p>\n","protected":false},"author":5,"featured_media":10674,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,11],"tags":[],"yoast_head":"\r\nSome tips for the SSIS Send HTML Email Task | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Some tips for the SSIS Send HTML Email Task - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Some tips for the SSIS Send HTML Email Task | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Some tips for the SSIS Send HTML Email Task - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2023-10-26T22:07:51+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-11-03T07:51:37+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/html-tricks-1.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"723\" \/>\r\n\t<meta property=\"og:image:height\" content=\"148\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/\",\"url\":\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/\",\"name\":\"Some tips for the SSIS Send HTML Email Task | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/html-tricks-1.png\",\"datePublished\":\"2023-10-26T22:07:51+00:00\",\"dateModified\":\"2023-11-03T07:51:37+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"Some tips for the SSIS Send HTML Email Task - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/html-tricks-1.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/html-tricks-1.png\",\"width\":723,\"height\":148,\"caption\":\"Example for the tables\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Some tips for the SSIS Send HTML Email Task\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Some tips for the SSIS Send HTML Email Task | ZappySys Blog","description":"Some tips for the SSIS Send HTML Email Task - ZappySys Blog","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:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/","og_locale":"en_US","og_type":"article","og_title":"Some tips for the SSIS Send HTML Email Task | ZappySys Blog","og_description":"Some tips for the SSIS Send HTML Email Task - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/","og_site_name":"ZappySys Blog","article_published_time":"2023-10-26T22:07:51+00:00","article_modified_time":"2023-11-03T07:51:37+00:00","og_image":[{"width":723,"height":148,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/html-tricks-1.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/","url":"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/","name":"Some tips for the SSIS Send HTML Email Task | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/html-tricks-1.png","datePublished":"2023-10-26T22:07:51+00:00","dateModified":"2023-11-03T07:51:37+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"Some tips for the SSIS Send HTML Email Task - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/html-tricks-1.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2023\/10\/html-tricks-1.png","width":723,"height":148,"caption":"Example for the tables"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/tips-ssis-send-html-email-task\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Some tips for the SSIS Send HTML Email Task"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10667"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=10667"}],"version-history":[{"count":8,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10667\/revisions"}],"predecessor-version":[{"id":11002,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10667\/revisions\/11002"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/10674"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=10667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=10667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=10667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}