SSIS CSV File Source - Read multiple CSV files, Import Gzip, Extract REST API data
*** WATCH NEW VIDEO: CLICK HERE *** • SSIS CSV File Source - Read from Flat File...
This video is made for the old version. Click the above link to watch for NEW CSV Source.
SSIS CSV File Source (Advanced Flat file source) can be used to read CSV data from local files or Web API (REST 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. For more info check this link https://zappysys.com/products/ssis-po...
=============
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 2005, 2008, 2012, 2014, 2016, 2017 (32 bit / 64 bit)
=============
Keywords
=============
Import compressed CSV file in SSIS
Read from CSV format API in SSIS
Import multiple Flat files in SSIS