Download Salesforce attachment in SSIS in an easy way

Contents

1 Introduction
2 Requirements
3 Getting Started
- 3.1 Creating the connection
- 3.2 Creating the package
4 Conclusion
- 4.1 Related

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 Salesforce Source into a file using SSIS. Working with images is always tricky the first time. However, with the right article, this process is really simple. This article will show you how simple it is to do it.

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.

Requirements

In order to do it, we will need the following components:

SSDT for SSIS installed
ZappySys SSIS Powerpack installed
A connection to Salesforce. In order to create a connection to Salesforce, check this video or check our article related.
Finally, we will need a file in Salesforce to download.

Getting Started

Creating the connection

First of all, in SSDT, create a new SSIS project
In order to create a connection in SSDT, go to the connection manager, and select a new connection.
ssis-create-salesforce-connection
Also, Select the ZS Salesforce connection. This new connection is created by the ZS SSIS PowerPack plugin mentioned in the requirements. With this connection, we can easily connect to Salesforce and get the Information.
Select SSIS Salesforce connection
Finally, write your email, password, and token. For more information about getting the token, please check our article related.
Salesforce credentials in SSIS

Creating the package

First of All, Drag and drop the Data Flow Task from SSIS Toolbox and double-click it to edit.
Drag and Drop : Data Flow Task from SSIS Toolbox
Secondly, in the Data Flow, we will use the Salesforce Source to connect to Salesforce and get the attachments.
Drag and Drop: Salesforce Source from SSIS Toolbox
For this purpose, we will use the attachment table from Salesforce.
In addition, we will get the columns from the table. The image is in the body, however, we have additional columns like the id, name, ContenType, BodyLenght, createDate, and more:
SSIS Salesforce Columns
Next, we will need to drag and drop SSIS Derived Column from the SSIS Toolbox below the Salesforce Source and connect it.
Drag and drop the Derived Column
Double-click on the derived column, to specify the path to store the image in a local folder.
SSIS-derived column download image salesforce
Now let’s, drag and drop SSIS Export Column from the SSIS Toolbox >> Other Transforms.
Drag and drop Export Column
Double-click on the Export column to download an image of the body. In the Extract Column map the Body column of File data and the Path Column to where you want to save that file.
SSIS export column salesforce image
Finally, we will use the trash destination to get the image and finish the flow.
SSIS Trash destination
Now, we are ready. Your package should be something like this:
ssis-full-download-package
Run the package to test it.
If everything is fine, we will be able to see the file. As you can see Downloading Salesforce Attachment in SSIS is a straightforward process.

Conclusion

In conclusion, we learned in this article how to Download Salesforce Attachment in SSIS. Basically, you need to use the ZappySys salesforce source, then use the derived column to specify the path and the Export column to get the image. Finally, the ZS Trash destination will be used If you liked this article, do not hesitate to continue testing and using ZappySys PowerPack for SSIS.