 |
ZappySys develops tools and connectors for Microsoft Business Intelligence, Azure, Amazon AWS, MongoDB and more... We provide everyday tools to make developer life easy. Check out our products including many FREE tools. If you are an MVP you may qualify for FREE MVP License |
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 2012, 2014, 2016, 2017 and 2019 (32 bit / 64 bit)
- Click here to see more articles on Azure related articles
- Click here to see more articles on CSV related articles
Screenshots
 |
SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more.
SSIS PowerPack also includes high quality FREE commercial components and tasks with full support/upgrade
Click here to read more ...
|
Why SSIS PowerPack?
- Coding free, drag & drop high performance suite of Custom SSIS Components and SSIS Tasks
- Used by many companies around the globe
- Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT
- No license needed if you are developing/testing in BIDS/SSDT
- Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email.
- 30 days money back guarantee if not satisfied for whatever reason.
Data Integration Categories
| |
