Query Salesforce Data using Bulk API in SSIS (read using SOQL query in Bulk mode / large dataset)

How to query salesforce data using Bulk API in SSIS

Introduction In our previous post, we saw how to read Salesforce data using SSIS Salesforce Source (Which uses SOAP API under the hood). This may be slow if you have millions of rows because Salesforce Source paginates every 2000 rows, so it’s not a good option to read millions of rows to iterate on a […]

How to create SSIS Package Programmatically (Add / Execute Tasks)

Introduction In this post, we will see how to create SSIS Package Programmatically to use ZappySys SSIS PowerPack. This blog post assumes you have basic knowledge of Programming language like C# and you have installed Visual Studio Express or a similar product (VS Code not supported). Add SSIS Dll References The very first thing is […]

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

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

SSIS PowerPack 4.1.0 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 OAuth Connection in SSIS

Download Gmail Attachment in SSIS

Introduction Download Gmail Attachment in SSIS is always a little bit difficult compared to work with a simple text or numeric columns. If you are not an expert in SSIS, doing that the first time may be Challenging. That is why we created this article for you. Doing this is a common request that we frequently receive […]