Introduction This release brings tons of new features and bug fixes. We have added a new connector for Excel Driver. To see full release notes click here New Features/Improvements NEW: All API Drivers – Add support for OAuth 1.0 with SHA256 (Usecase like NetSuite API) NEW: All API Drivers – Add Support for Tls 1.3 NEW: All API Drivers […]
Author Archives: ZappySys
ODBC PowerPack 1.5.1 released
Introduction This release had many bug fixes. To see full release notes click here New Features/Improvements NEW: JDBC Bridge Driver – Prefix schema name to table when you select it from table dropdown and default query is generated (by default schema is not prefixed) Bug fixes FIX: All API Drivers – Add support for Page End Indicator / […]
SSIS PowerPack 4.2.3 released
Introduction This was a minor update release. It fixes important issues with API Source, API Destination, DynamoDB, Export XML Task, JSON Source, CSV Source, XML Source, Upsert Destination and Salesforce Source. To see full release notes click here New Features/Improvements NEW: API Connector – SharePoint Online – Add new endpoint get_list_items_dynamic to read complex datatypes (e.g. Lookup, […]
SSIS PowerPack 4.2.2 released
Introduction This was a minor update release. It have added a new API Connectors for Google Drive, SharePoint Online & Zoho. Also, It fixes important issues with API Source, API Destination, Salesforce Source and Web API Destination. To see full release notes click here New Features/Improvements NEW: API Connector – Google Drive – Add support for very […]
ODBC PowerPack 1.4.2 released
Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around All API Drivers and Multi statement support in Salesforce Driver. We also added many new features in various drivers along with bug fixes/performance improvement features. To see full release notes click here New Features/Improvements NEW: All […]
SSIS PowerPack 4.1.3 released
Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for popular API services. We also added many new features in various tasks / components along with bug fixes / performance improvement features. To see full release notes […]
SSIS PowerPack 4.1.2 released
Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for popular API services. We also added many new features in various tasks / components along with bug fixes / performance improvement features. To see full release notes […]
SSIS PowerPack 4.1.1 released
Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for popular API services. We also added many new features in various tasks / components along with bug fixes / performance improvement features. To see full release notes […]
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 / […]
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. […]