{"id":774,"date":"2016-09-07T16:47:38","date_gmt":"2016-09-07T16:47:38","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=774"},"modified":"2023-09-05T06:48:29","modified_gmt":"2023-09-05T06:48:29","slug":"ssis-base64-encode-decode-without-coding","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/","title":{"rendered":"SSIS Base64 Encode Decode without Coding"},"content":{"rendered":"

Introduction<\/h2>\n

In this post you will learn how to use FREE SSIS Logging Task<\/a> to perform ssis base64 encode decode and save to Variable or File\u00a0 (i.e. convert Base64 Encoded value to plain text or encode plain text to base64) . You can also use many other format specifiers found here<\/a><\/p>\n

How to invoke Placeholder Functions<\/h2>\n

There are 3 ways you can use placeholder functions in many tasks with Variable Icon next to the property.<\/p>\n

    \n
  1. User Variable Placeholder<\/li>\n
  2. Static String Placeholder<\/li>\n
  3. Mixed Placeholder (Static String with Variable)<\/li>\n<\/ol>\n

    Examples:\u00a0<\/strong><\/p>\n

    {{User::var1,FUN_BASE64ENC}}\u00a0<\/span>
    \n–OR–<\/strong>
    \n<<some direct string,FUN_BASE64ENC>><\/span><\/p>\n

    –OR–<\/strong><\/p>\n

    <<{{User::var1}} and {{User::var2}} ,FUN_BASE64ENC>><\/span><\/p>\n

    Encode\u00a0Plain text to Base64 string (SSIS base64 encode decode)<\/h2>\n

    Many times you have requirement to convert plain text into Base64 encoded string (This is very common when you have to transfer data over the web – set query string \/ http headers \/ body ). Typically to perform this you may have to write C# Script if you are SSIS developer but below is very simple way to do without writing any code. Here is the most common use case of Base64 encoded string<\/a><\/p>\n

      \n
    1. Download FREE Tasks\/Components of SSIS PowerPack<\/a><\/li>\n
    2. Create new SSIS Package<\/li>\n
    3. Drag ZS Logging Task from Toolbox<\/li>\n
    4. Create SSIS variable which holds plain text value (Lets call it varPlainText. Set some initial value which you want to encode)<\/li>\n
    5. Configure SSIS Logging Task<\/span><\/u> as below\n
    6. Run it and you will see new file created with encoded value. You can also save encoded value to Variable if you change Logging Mode = Variable<\/strong> rather than File<\/li>\n<\/ol>\n

      Convert Base64 Encoded value to plain text (Decode)<\/h2>\n

      To convert Base64 encoded string into plaintext you can perform similar steps described in the above section except you need to use BASE64DEC format specifier rather than BASE64ENC<\/p>\n

      Example:<\/strong><\/p>\n

      <<QUJDREVGMTIzIyM=,FUN_BASE64DEC>>\r\n--OR--\r\n{{User::MySSISVar1,FUN_BASE64DEC}}<\/pre>\n
       <\/p>\n
      How to decode Base64 file in SSIS and save to new file<\/h2>\n
      If you have a file coming as a base64 encoded string and you want to decode it and save it to a new file then it’s simple too. Basically, you will need SSIS Advanced File System Task<\/a>\u00a0 and SSIS Logging Task<\/u><\/span>\u00a0to achieve this (see package below).<\/p>\n
      \"SSIS<\/a>
      SSIS decode base64 file – Read content convert to plain text and save to new file<\/p><\/div>\n
      Here are your steps.<\/p>\n
        \n
      1. Use SSIS Advanced File System Task<\/a> and use read file content option to save file content into SSIS Variable<\/li>\n
      2. Configure Advanced File System as below.\n
      3. Next step connect SSIS Logging Task<\/span><\/u><\/li>\n
      4. Configure SSIS Logging Task as per below screenshot.\n
        \"Decode<\/a>
        Decode base64 file content in SSIS – Use Logging Task<\/p><\/div><\/li>\n<\/ol>\n
        Convert Base64 Encoded string of local file content (Binary or Text)<\/h2>\n
        Using\u00a0FUN_FILE_BASE64ENC we can encode the image or any other local file(Binary or Text) to the Base64 string.<\/p>\n
        FUN_FILE_BASE64ENC<\/h3>\n
        Syntax:<\/strong><\/p>\n
        <<file_path,FUN_FILE_BASE64ENC>><\/pre>\n
        Returns BASE64 encoded string of local file content (binary or text).<\/p>\n
        Parameters:<\/h4>\n\n\n\n\n\n
        Name<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
        file_path<\/td>\n[String] File path for which you like encode content as Base64.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        Examples:<\/h4>\n
        <<c:\\someimage.png,FUN_FILE_BASE64ENC>>\r\n--OR--\r\n{{User::MySSISVar1,FUN_FILE_BASE64ENC}}<\/pre>\n
        Sample Output:<\/h4>\n
        This returns base64 encoded string of binary file (png)<\/p>\n
        bXl1c2V..........Ac3NXb3Jk<\/pre>\n","protected":false},"excerpt":{"rendered":"
        Introduction In this post you will learn how to use FREE SSIS Logging Task to perform ssis base64 encode decode and save to Variable or File\u00a0 (i.e. convert Base64 Encoded value to plain text or encode plain text to base64) . You can also use many other format specifiers found here How to invoke Placeholder […]<\/p>\n","protected":false},"author":1,"featured_media":776,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[145],"tags":[147,12,79,146,4],"yoast_head":"\r\nSSIS Base64 Encode Decode without Coding | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS Base64 Encode Decode without Coding. Learn how to convert plain text into Base64 encoded string \/ decode base64 string into plain text and save to file\" \/>\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\/ssis-base64-encode-decode-without-coding\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS Base64 Encode Decode without Coding | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS Base64 Encode Decode without Coding. Learn how to convert plain text into Base64 encoded string \/ decode base64 string into plain text and save to file\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-09-07T16:47:38+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-09-05T06:48:29+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/09\/ssis-base64-encode-decode-without-coding.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1010\" \/>\r\n\t<meta property=\"og:image:height\" content=\"614\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\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\/ssis-base64-encode-decode-without-coding\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/\",\"name\":\"SSIS Base64 Encode Decode without Coding | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/09\/ssis-base64-encode-decode-without-coding.png\",\"datePublished\":\"2016-09-07T16:47:38+00:00\",\"dateModified\":\"2023-09-05T06:48:29+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"SSIS Base64 Encode Decode without Coding. Learn how to convert plain text into Base64 encoded string \/ decode base64 string into plain text and save to file\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/09\/ssis-base64-encode-decode-without-coding.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/09\/ssis-base64-encode-decode-without-coding.png\",\"width\":1010,\"height\":614,\"caption\":\"SSIS Base64 Encode, Decode using SSIS Logging Task (Without coding convert plain text to base 64 string)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS Base64 Encode Decode without Coding\"}]},{\"@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\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS Base64 Encode Decode without Coding | ZappySys Blog","description":"SSIS Base64 Encode Decode without Coding. Learn how to convert plain text into Base64 encoded string \/ decode base64 string into plain text and save to file","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\/ssis-base64-encode-decode-without-coding\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Base64 Encode Decode without Coding | ZappySys Blog","og_description":"SSIS Base64 Encode Decode without Coding. Learn how to convert plain text into Base64 encoded string \/ decode base64 string into plain text and save to file","og_url":"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-09-07T16:47:38+00:00","article_modified_time":"2023-09-05T06:48:29+00:00","og_image":[{"width":1010,"height":614,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/09\/ssis-base64-encode-decode-without-coding.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/","url":"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/","name":"SSIS Base64 Encode Decode without Coding | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/09\/ssis-base64-encode-decode-without-coding.png","datePublished":"2016-09-07T16:47:38+00:00","dateModified":"2023-09-05T06:48:29+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"SSIS Base64 Encode Decode without Coding. Learn how to convert plain text into Base64 encoded string \/ decode base64 string into plain text and save to file","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/09\/ssis-base64-encode-decode-without-coding.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/09\/ssis-base64-encode-decode-without-coding.png","width":1010,"height":614,"caption":"SSIS Base64 Encode, Decode using SSIS Logging Task (Without coding convert plain text to base 64 string)"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-base64-encode-decode-without-coding\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS Base64 Encode Decode without Coding"}]},{"@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\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/774"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=774"}],"version-history":[{"count":11,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/774\/revisions"}],"predecessor-version":[{"id":10343,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/774\/revisions\/10343"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}