{"id":9190,"date":"2020-12-26T20:25:11","date_gmt":"2020-12-26T20:25:11","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=9190"},"modified":"2023-08-22T12:53:03","modified_gmt":"2023-08-22T12:53:03","slug":"download-salesforce-attachment-in-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/","title":{"rendered":"Download Salesforce Attachment in SSIS"},"content":{"rendered":"

Introduction<\/h2>\n

Download Salesforce Attachment in SSIS can be difficult the first time. In this new article, we will show how to download an Attachment from the\u00a0Salesforce Source<\/a> into a file using SSIS. Working with images is always\u00a0tricky the first time. However, with the right article, this process is really\u00a0simple. This article will show you how simple it is to do it.<\/p>\n

Salesforce is an extremely powerful CRM based in the cloud. This company was created in California, San Francisco and it is a very common request to get the information from the cloud into a file automatically. These can be achieved with our ZappySys SSIS PowerPack plus some SSIS tasks.<\/p>\n

Requirements<\/h2>\n

In order to do it, we will need the following components:<\/p>\n

    \n
  1. SSDT for SSIS<\/a> installed<\/li>\n
  2. ZappySys SSIS Powerpack<\/a> installed<\/li>\n
  3. A connection to Salesforce. In order to create a connection to\u00a0Salesforce, check\u00a0this video\u00a0<\/a>or\u00a0check our article related<\/a>.<\/li>\n
  4. Finally, we will need a file in Salesforce to download.<\/li>\n<\/ol>\n

    Getting Started<\/h2>\n

    Creating the connection<\/h3>\n
      \n
    1. First of all, in SSDT, create a new SSIS project<\/li>\n
    2. In order to create a connection in SSDT, go to the connection manager, and select a new connection.\n
    3. Also, Select the ZS Salesforce connection. This new connection is created\u00a0by the ZS SSIS PowerPack<\/a> plugin mentioned in the requirements. With this connection,\u00a0we can easily connect to Salesforce and get the Information.\n
    4. Finally, write your email, password, and token. For more information\u00a0about getting the token, please\u00a0check our article related<\/a>.\n
      \"SSIS

      Salesforce credentials in SSIS<\/p><\/div><\/li>\n<\/ol>\n

      Creating the package<\/h3>\n
        \n
      1. First of All, Drag and drop the Data Flow Task from SSIS Toolbox and double-click it to edit.\n
      2. Secondly, in the Data Flow, we will use the Salesforce Source to connect to Salesforce and get the attachments.\n
      3. For this purpose, we will use the attachment table from Salesforce.\"\"<\/a><\/li>\n
      4. In addition, we will get the columns from the table. The image is in the\u00a0body, however, we have additional columns like the id, name, ContenType,\u00a0BodyLenght, createDate, and more:\n
      5. Next, we will need to drag and drop SSIS Derived Column from the SSIS Toolbox below the Salesforce Source and connect it.\n
      6. Double-click on the derived column, to specify the path to store the image in a local folder.\n
      7. Now let’s, drag and drop SSIS Export Column from the SSIS Toolbox >> Other Transforms.\n
      8. Double-click on the Export column to download an image of the\u00a0body.\u00a0In the Extract Column map the Body column of File data and the Path Column to where you want to save that file.\n
      9. Finally, we will use the trash destination to get the image and finish\u00a0the flow.\n
      10. Now, we are ready. Your package should be something like this:\n
      11. Run the package to test it.<\/li>\n
      12. If everything is fine, we will be able to see the file. As you can see\u00a0Downloading Salesforce Attachment in SSIS is a straightforward process.<\/li>\n<\/ol>\n

         <\/p>\n

        Conclusion<\/h2>\n

        In conclusion, we learned in this article how to Download Salesforce Attachment in SSIS. Basically, you need to use the ZappySys salesforce source,\u00a0then use the derived column to specify the path and the Export column to get the\u00a0image. Finally, the ZS Trash destination will be used\u00a0 If you liked this article, do not hesitate to continue testing\u00a0and using ZappySys PowerPack for SSIS.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

        Introduction Download Salesforce Attachment in SSIS can be difficult the first time. In this new article, we will show how to download an Attachment from the\u00a0Salesforce Source into a file using SSIS. Working with images is always\u00a0tricky the first time. However, with the right article, this process is really\u00a0simple. This article will show you how […]<\/p>\n","protected":false},"author":5,"featured_media":9202,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[176,233],"tags":[587,210,12],"yoast_head":"\r\nDownload Salesforce attachment in SSIS in an easy way<\/title>\r\n<meta name=\"description\" content=\"In this article, we will see how to Download Salesforce attachment in SSIS in any version. We will show an easy way to do it.\" \/>\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\/download-salesforce-attachment-in-ssis\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Download Salesforce attachment in SSIS in an easy way\" \/>\r\n<meta property=\"og:description\" content=\"In this article, we will see how to Download Salesforce attachment in SSIS in any version. We will show an easy way to do it.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-12-26T20:25:11+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-08-22T12:53:03+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/12\/ssis-create-gmail-connection.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"550\" \/>\r\n\t<meta property=\"og:image:height\" content=\"315\" \/>\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\/download-salesforce-attachment-in-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/\",\"name\":\"Download Salesforce attachment in SSIS in an easy way\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/12\/ssis-create-gmail-connection.png\",\"datePublished\":\"2020-12-26T20:25:11+00:00\",\"dateModified\":\"2023-08-22T12:53:03+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"In this article, we will see how to Download Salesforce attachment in SSIS in any version. We will show an easy way to do it.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/12\/ssis-create-gmail-connection.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/12\/ssis-create-gmail-connection.png\",\"width\":550,\"height\":315,\"caption\":\"ssis-create-salesforce-connection\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Download Salesforce Attachment in SSIS\"}]},{\"@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":"Download Salesforce attachment in SSIS in an easy way","description":"In this article, we will see how to Download Salesforce attachment in SSIS in any version. We will show an easy way to do it.","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\/download-salesforce-attachment-in-ssis\/","og_locale":"en_US","og_type":"article","og_title":"Download Salesforce attachment in SSIS in an easy way","og_description":"In this article, we will see how to Download Salesforce attachment in SSIS in any version. We will show an easy way to do it.","og_url":"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/","og_site_name":"ZappySys Blog","article_published_time":"2020-12-26T20:25:11+00:00","article_modified_time":"2023-08-22T12:53:03+00:00","og_image":[{"width":550,"height":315,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/12\/ssis-create-gmail-connection.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\/download-salesforce-attachment-in-ssis\/","url":"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/","name":"Download Salesforce attachment in SSIS in an easy way","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/12\/ssis-create-gmail-connection.png","datePublished":"2020-12-26T20:25:11+00:00","dateModified":"2023-08-22T12:53:03+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"In this article, we will see how to Download Salesforce attachment in SSIS in any version. We will show an easy way to do it.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/12\/ssis-create-gmail-connection.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/12\/ssis-create-gmail-connection.png","width":550,"height":315,"caption":"ssis-create-salesforce-connection"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/download-salesforce-attachment-in-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Download Salesforce Attachment in SSIS"}]},{"@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\/9190"}],"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=9190"}],"version-history":[{"count":11,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9190\/revisions"}],"predecessor-version":[{"id":10222,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9190\/revisions\/10222"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/9202"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=9190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=9190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=9190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}