ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

ODBC PowerPack 1.6.0 released

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 […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

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 / […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

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, […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

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 […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

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 […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

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 […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

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 […]

ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence

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 / […]

Azure BLOB Storage

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. […]