How to download images from a web page using SSIS

Introduction The article shows how to download images from a web page using SSIS. Sometimes we need to download the images from a web page. In this post, we will show how to do this. Prerequisites Before we perform steps listed in this article, you will need to make sure following prerequisites are met: SSIS […]

How to get all URLs from emails from Outlook

Introduction This time we will explain how to get all URLS from emails using MS Outlook. Sometimes we need get all URLs from emails. In this post, we will show how to do this. Step by step using SSIS. Microsoft Graph API is a unified way to access many Microsoft services API including Office 365 API Prerequisites Before […]

How to add row numbers in SSIS data flow

Problem Sometimes Data Flow source does not contain an ID column, or a number indicating a row number, which you need in further steps. To solve this, you may use a free ZappySys PowerPack component Template Transform. So let’s take a look at how to accomplish that.     Tip Add Template Transform Go to […]

How to compare records in SSIS using hash

Introduction In this blog,  we are going to learn to how to compare records in SSIS using hash method. We will use FREE Template Transform component along with Sort Transform, Merge Join Transform and Conditional Split Transform. We will see how to produce hash value from multiple columns and later compare source\target hash values to detect changes\new rows. Data […]

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