SSIS CSV File Source - Read from Flat File or Web API / Load into SQL Server Table / Import CSV File

Learn how to read CSV data from local files or Web API and load into SQL Server Table in SSIS (Using UPSERT Destination)

00:31 Add CSV Source in the Package
01:35 Read from REST API (Get/Post Method)
01:58 Setup API Connection - HTTP / OAuth
04:05 Editing Columns Metadata for CSV
04:50 Load CSV data into SQL Server (UPSERT - Insert or Update)

SSIS CSV File Source (Flat File or Web API)
=========================================
SSIS CSV File Source Connector (Advanced Flat file source) can be used to read CSV data from local files or Web API. You can extract data from single or multiple files (wildcard pattern supported). Also you can read compressed files (*.gz) without extracting files on disk.

Features
==========================================
* Support for reading CSV data from Web API call or file(s) stored on local disk
* Support for reading single or multiple files (wildcard pattern supported e.g. *.csv)
* Support for reading zip and gzip compressed files (stream mode)
* Support for OAuth and HTTP Basic Authentication along with many security features
* Support for missing columns at the end (Auto fill with null values)
* Support for data pivot (transform columns into rows)
* Support for comments in the file
* Support for advanced error handling such as throw error for empty file, throw error when column count mismatch
* Support for Advanced parser options such as Trim fields, Trim headers, Skip rows
* Support for ignoring blank lines and blank rows (no data for each column)
* Support for Dynamic file path using variable placeholder (e.g. c:\data\{{User::MyFolder}}\*.csv )
* Support for SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory

Related Searches:
===========================================
Read from CSV File in SSIS
Load REST API data into SQL Server Table
Import REST API data into SQL Server Table
Pivot CSV Data in SSIS
UPSERT into SQL Server
GET data from URL (API)
Read CSV in SSIS
Read API in SSIS
Read REST API in SSIS
Call REST API in SSIS