How to detect missing columns in SSIS

How to detect extra columns or missing columns Sometimes, we need to validate the input columns to check if there are some extra columns or missing columns in SSIS. ZappySys includes some pretty nice tools, but some of them cannot check the required values. To fix that problem, you can complement these tools with our Regular Expression Parser […]

Twilio

Read data from Twilio API in SSIS

Introduction In our previous article we see How to call REST API in SSIS . Now in this article, we will see example of how to Make Twilio API Call in SSIS and load into SQL Server. This blog mainly focuses on SSIS approach but steps mentioned to call Twilio API Call can be useful for any developer […]

MailPlus

How to Make MailPlus OAuth 1.0a REST API Call in SSIS

Introduction In our previous article we see How to read call REST API data in SSIS. Now in this article, we will see How to Make MailPlus OAuth 1.0a REST API Call in SSIS and load into SQL Server. This blog mainly focuses on SSIS approach but steps mentioned to call MailPlus Oauth 1.0a REST API Call […]

PayPal

How to Make PayPal API Call in ODBC / SQL Server (T-SQL)

Introduction In our previous article we saw how to call PayPal API in SSIS. Now in this article, we will see How to Make PayPal API Call in ODBC from the SQL Server. This blog mainly focuses on ODBC approach but steps mentioned to call PayPal APIs can be useful for any developer regardless of which […]

Pivot JSON / XML Data option for ZappySys API Connectors / Drivers

Pivot JSON and XML data using SSIS or ODBC Drivers

Introduction In our previous post we saw various ways to transform JSON arrays. However there will be a time when your JSON / XML file wont have Array and you need to Pivot JSON Data. Sample JSON data file Here is a sample JSON file which we like to parse into rows and columns. Notice […]

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

SSIS PowerPack v2.9.6 released

What’s New In this release we added UPSERT support for PostgreSql and Redshift via our Upsert Destination. You can now choose connection manager for these 2 extra data source types and get fast bulk Upsert. We also fixed few important bugs with salesforce destination. Version 2.9.7.10822 [Sep 03, 2019] New Features/Improvements NEW: All API Tasks – […]

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

ODBC PowerPack v1.1.4 Released

What’s New In this version we focused on many bug fixes. Among them most important bug was limitation of only 2000 characters for SQL Query using OPENQUERY statement. Now you can use up to 8000 characters for OPENQUERY and if that’s not enough use EXEC AT statement to send query to Data Gateway. We also […]

Access-to-AmazonRedshift

Merge / Upsert data in Amazon Redshift using SSIS

Introduction In our previous blog we saw how update / insert data into SQL Server using SSIS Upsert Destination. In this post we will look at specific example on Data migration from Access to Amazon Redshift using SSIS Upsert Destination (Insert, Update, Delete), along with few other topics such as how to create table using […]