SSIS CSV Source Connector (Flat File or Web API)

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
  • Click here to see more articles on Azure related articles
  • Click here to see more articles on CSV related articles

Download Help File Buy
View All Tasks
ScreenshotsArticles / Useful LinksSystem Requirements

SSIS CSV File Source – Read from Web API Options

SSIS CSV File Source - Read from Web API Options

SSIS CSV File Source – Read from Web API Options

SSIS CSV File Source – Read from CSV Files Options

SSIS CSV File Source - Read from CSV Files Options

SSIS CSV File Source – Read from CSV Files Options

SSIS CSV File Source – Read Compressed CSV File (GZip or Zip)

SSIS CSV File Source - Read Compressed CSV File (GZip or Zip)

SSIS CSV File Source – Read Compressed CSV File (GZip or Zip)

SSIS CSV File Source – Error Handling Options

SSIS CSV File Source - Error Handling Options

SSIS CSV File Source – Error Handling Options

SSIS CSV File Source – Advanced CSV Parsing Options

SSIS CSV File Source - Advanced CSV Parsing Options

SSIS CSV File Source – Advanced CSV Parsing Options

SSIS CSV File Source – DateTime Parsing Options

SSIS CSV File Source - DateTime Parsing Options

SSIS CSV File Source – DateTime Parsing Options

SSIS CSV File Source – Design time data preview

SSIS CSV File Source - Design time data preview

SSIS CSV File Source – Design time data preview

SSIS CSV File Source – Redirect Bad Records (Error Handling)

SSIS CSV File Source - Redirect Bad Records (Error Handling)

SSIS CSV File Source – Redirect Bad Records (Error Handling)

Articles / Tutorials

Click here to see all articles for [SSIS CSV Source] category


How to Pivot CSV Data in SSIS

How to Pivot CSV Data in SSIS

Introduction In our previous blog we saw How to write data into CSV file in SSIS (GZip / Split). Now in this blog, we will see How to Pivot CSV Data in SSIS using CSV Source. It also supports Pivot mode so you can convert single CSV string value into Rows. In this article we […]


SSIS Magento data Read / Write using REST API Call

SSIS Magento data Read / Write using REST API Call

Introduction In this post we will lean SSIS Magento data read / write operations. Magento is a very popular eCommerce platform and they offer JSON based REST API and XML based SOAP API. You can use either API based on your need to automate common integration needs. We recommend using REST API (JSON API) if possible […]


How to call Amazon MWS API using SSIS

How to call Amazon MWS API using SSIS

Introduction In this post you will learn how to call Amazon MWS API (Amazon Marketplace Web Service) or Amazon Product Advertising API using SSIS PowerPack. Using drag and drop approach you can consume data from Amazon MWS XML Web service. In this post we will use ZappySys XML Source connector to read data from Amazon MWS […]

Click here to learn more about System Requirements
Download View All Tasks Like This