Introduction If you have need to integrate REST API in SSIS (i.e. fetch JSON, XML, CSV via HTTP call) and wondering how to Read API data in SSIS and Load into SQL DB (i.e. SQL Server, MySQL, Oracle) then you are at the right place. In this article we will cover simple step by step […]
Category Archives: SSIS PowerPack
How to call OneDrive API in SSIS (Upload, Download)
Introduction Microsoft Graph API is a unified way to access many Microsoft services API including OneDrive API. In our previous blog post we saw how to call Office 365 API Graph API. In this post, you will focus on how to access OneDrive API in SSIS and use REST API Task or connector like SSIS JSON / […]
Extract audit data from SSIS Execution Log (EventHandler and Regular Expression)
Introduction In our last post (Regex Cheat Sheet) we explained use cases of SSIS Regular Expression Parser Task . Now lets look at some real world usecase. Basically in this article we are going to Extract data from audit log using SSIS. For demo purpose we will use log generated by SSIS Export CSV File Task output. When […]
How to read Salesforce Metadata in SSIS using REST API (JSON Source)
Introduction In our previous posts we saw how to read and write Salesforce Data using SSIS. In this post we will see how to read Salesforce Metadata in SSIS using JSON Source. Step-By-Step In this section you will learn how to use ZappySys JSON Source Adapter to extract data from Salesforce REST API (JSON Format). You […]
How to connect to MongoDB Atlas in SSIS (Replica Set)
Introduction In our previous post we saw how to read / write MongoDB data using ZappySys MongoDB Source and Destination. However it was all about connecting to On Premises hosted version of MongoDB. In this post you will focus on specifically on how to connect to MongoDB Atlas in SSIS (MongoDB Hosted in Cloud). MongoDB Atlas […]
How to make Web API Destination dynamic (URL, Body, Headers)
Introduction In this article, we will show how to work with the Web API Destination and create a dynamic URL, Body or header. For this purpose, we will use the following components: ZappySys SSIS PowerPack component to make things work: In these examples, we are going to show different examples of how to send a dynamic URL, dynamic […]
How to Get Office 365 Mail Attachments using SSIS
Introduction In our previous article, we saw How to Get Office 365 data in Power BI. Now let’s look at How to Get Office 365 Mail Attachments using SSIS without any coding. Microsoft Graph API is a unified way to access many Microsoft services API including Office 365 API. In this post, we will use SSIS JSON / […]
How to convert SQL to CSV in SSIS
How to convert SQL to CSV in SSIS There are several tricks related to convert SQL to CSV. For example, dates, working with variables, converting text, working with stored procedures. In this article, we will work with several tips to convert SQL Server data to the CSV format using CSV. For this article, we will use the following […]
Download the Latest File from Azure Blob Storage using SSIS
Introduction In our previous article, we saw SSIS Azure Blob Storage task examples. Now let’s look at how to Download the Latest File from Azure Blob Storage using SSIS. Microsoft SSIS includes the Azure Blob Storage Storage Task that allows us to upload files to Azure Blob Storage, download files, creating local and remote directories an more. […]
Download the Latest File from Amazon S3 Storage using SSIS
Introduction In our previous article, we saw SSIS Amazon S3 Storage Task examples. Now let’s look at how to Download the Latest File from Amazon S3 Storage using SSIS. Microsoft SSIS includes the Amazon S3 Storage Task that allows us to upload files to Amazon S3 Storage, download files, creating local and remote directories an more. In […]