Tip – How to fix UI scaling issue on Windows 10 and 7

Problem Many customers reported issue regarding UI not scaling correctly on certain machines (windows 10 and windows 7). If you have similar issue then most likely its due to System Font Scale (DPI) is set to higher than 100%. Perform following steps to verify/fix it. Sometimes maximizing the window will show correct UI elements so […]

How to Insert Multiple Documents into MongoDB using SSIS

Introduction In this post you will learn how to use MongoDB ExecuteSQL Task for SSIS to insert multiple documents into MongoDB collection using SSIS. This task can be used to perform any DDL or DML operations for MongoDB natively inside SSIS without using any command line utilities. It gives you flexibility and security of SSIS. […]

Create SOAP Request Body from WSDL (Using SoapUI tool)

Calling SOAP Web Service in SSIS (XML Source)

Introduction In this article, you will learn how to call SOAP Web Service in SSIS. We will use drag and drop approach to consume SOAP Webservice using SSIS XML Source Connector. This same XML Connector can be used to consume data from local XML Files (wild card allowed e.g. *.xml) or you can consume XML stored in […]

How to add / remove MongoDB User in SSIS

Introduction In this blog post, you will learn how to call MongoDB Shell Commands from SSIS using MongoDB ExecuteSQL task Some of the use cases of calling MongoDB shell commands are listed here.   How to call MongoDB Shell Commands in SSIS Download and install SSIS PowerPack from here From toolbox of SSIS designer drag  ZS […]

create-facebook-oauth-app-developer-graph-api-1

How to register Facebook OAuth App for Graph API Access

Introduction In this article, you will learn how to register Facebook OAuth App (Graph API) for data access using SSIS PowerPack REST API Connectors. Using SSIS PowerPack you can consume/manage Facebook data by calling Graph API. These connectors have drag and drop UI so you can do data integration without any coding (e.g. C#, Java, […]

How to get data from Google AdWords using SSIS

Introduction Google AdWords is one of the most popular Advertise Platforms. In this article, you will learn how to get data from Google AdWords by calling Google AdWords Web Service method and using drag and drop SSIS XML/SOAP connector (No coding required :)). Google AdWords Web Services allows retrieving various data such as account info, campaigns; […]

POST file data using SSIS ( Raw file upload)

REST API File Upload using SSIS (Multi Part POST)

Introduction In this post you will learn how to use SSIS REST API Task to perform REST API File Upload (i.e. RESTful file upload) to web server. Typically to access REST API you may have to use programming language but in this post we will use visual drag and drop approach. File upload using HTTP/HTTPS […]

SSIS REST API Example - Call with 301 / 302 Redirect

Calling Web API in SSIS with Authorization and Redirect

Introduction In some cases when you call API to http URL it may redirect you to different location (Also known as 301 or 302 redirect). Best example is when you type https://www.zappysys.com it will redirect you to https://zappysys.com. This can cause issue in some case if you are passing credentials (i.e. UserID / Password) because […]

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

How to count file columns in SSIS using C# Script

Here is the snippet which can be used to count total columns in your flat file. Below script assume that you have column count based on separator=comma. if you use different separator then just change script accordingly

 

Create New Google API Project (Google API - Register new OAuth App)

How to register Google OAuth Application (Get ClientID and ClientSecret)

Introduction In our previous article we understood little bit about OAuth 2.0 Protocol. We talked how to use Default App for ease of use. However In this post you will learn how to register Google OAuth Application so you can access various Google Services programmatically (e.g Youtube, Google Analytics, AdWords, DoubleClick etc.). Here is the […]