How to add / remove MongoDB User in SSIS

Updated on November 14, 2018 by ZappySys

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

Updated on March 6, 2019 by ZappySys

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

Updated on April 17, 2025 by ZappySys

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)

Updated on July 23, 2020 by ZappySys

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

Updated on December 8, 2017 by ZappySys

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

How to count file columns in SSIS using C# Script

Posted on May 1, 2016 by ZappySys

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

        public void Main()
        {
            // TODO: Add your code here

            var colCnt = GetFileColumns("file1",',');
            MessageBox.Show("Your file has total " + colCnt + " columns");
            Dts.TaskResult = (int)ScriptResults.Success;
        }
        private int GetFileColumns(string connName,char colSeperator= ',')
        {
            var filePath=Dts.Connections[connName].ConnectionString;
            string firstline;
            using (System.IO.StreamReader sr = new System.IO.StreamReader(filePath))
            {
                 firstline= sr.ReadLine();
            }              
            var colArr=firstline.Split(new char[]{colSeperator});
            return colArr.Length;
        }

public void Main()

{

// TODO: Add your code here

var colCnt = GetFileColumns("file1",',');

MessageBox.Show("Your file has total " + colCnt + " columns");

Dts.TaskResult = (int)ScriptResults.Success;

}

private int GetFileColumns(string connName,char colSeperator= ',')

{

var filePath=Dts.Connections[connName].ConnectionString;

string firstline;

using (System.IO.StreamReader sr = new System.IO.StreamReader(filePath))

{

firstline= sr.ReadLine();

}

var colArr=firstline.Split(new char[]{colSeperator});

return colArr.Length;

}

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

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

Updated on June 5, 2024 by ZappySys

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

How to do REST API Pagination in SSIS / ODBC Drivers

Updated on November 22, 2023 by ZappySys

Introduction In our previous blog, we saw how to call REST in SSIS including concepts of Authentication / Error Handling. Now in this post, we will cover API Pagination. You will learn concepts and patterns about REST API Pagination (for JSON / XML / SOAP or CSV API). We will describe methods and steps to implement REST API […]

How to find amazon s3 bucket location (AWS region endpoint)

How to check Amazon S3 Bucket location (Region)

Posted on March 15, 2016 by ZappySys

Problem Sometimes if you loading data to Redshift via COPY command or using SSIS Redshift Data Transfer Task to move data to redshift then you will have to make sure your S3 Bucket is in the same region as Redshift Cluster. Many people don’t know how to verify that because its hidden in the console. This […]

SSIS – Loading data into MongoDB (Upsert, Delete, Update)

Updated on November 14, 2018 by ZappySys

Introduction MongoDB is one of the most poplar NoSQL database out there. In this article you will learn how to use ZappySys MongoDB Destination Connector to perform various bulk operations on MongoDB such as Insert, Update, Delete and Upsert. If you wish to learn how to Update MongoDB Array items then check this blog post instread. […]