SSIS Secure FTP CSV File Source Connector

SSIS FTP Source for CSV Files

SSIS Secure FTP Source for CSV files can be used to read CSV files from Secure FTP Storage (Using FTP, SFTP, FTPS or FTP/SSL Protocols). 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 single or multiple files stored in Secure FTP Storage (wildcard pattern supported e.g. *.csv)
Support for reading zip and gzip compressed files (stream mode)
Support for FTP (Classic FTP), SFTP, FTPS or FTP/SSL Protocols
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. /myroot/{{User::MyFolder}}/*.csv )
Support for SQL Server 2022, 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

SSIS Secure FTP CSV File Source Connector - Video Tutorial

SSIS Secure FTP CSV File Source – Read from CSV File Options

SSIS Secure FTP CSV File Source – Create Azure Storage Connection

SSIS Secure FTP CSV File Source – Select CSV File(s) using Blob Browser UI

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

SSIS Secure FTP CSV File Source – Error Handling Options

SSIS Secure FTP CSV File Source – Advanced CSV Parsing Options

SSIS Secure FTP CSV File Source – DateTime Parsing Options

SSIS Secure FTP CSV File Source – Design time data preview

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

Articles / Tutorials

Click here to see all articles for [SSIS Secure FTP CSV File] category

SSIS Data Load SQL Server to FTP/SFTP (Split Files, GZip)

Introduction In this blog post you will see how easy it is to load large amount of data from SQL Server to FTP/SFTP. SSIS Data Load SQL Server to FTP/SFTP (Split Files, GZip). For demo purpose we will use SQL Server as relational source but you can use same steps for any database engine […]

Read SFTP / FTP Files in SSIS (CSV, JSON, XML)

Introduction In our previous blog, we saw how to perform SFTP / FTP File Operations in SSIS. Now in this blog, we will see How to Read SFTP / FTP Files in SSIS (CSV, JSON, XML Format files). To illustrate, we will useÂ ZappySys SSIS PowerPack, which includes several tasks to import/export data from multiples sources […]

Download latest File from FTP using SSIS (SFTP / FTPS)

Introduction In this blog, we will learn how to Download Latest File from FTP using SSIS Secure FTP Task, We also learn how to connect with FTP/SFTP and also see how to Get Latest File list in ADO.net DataTable variable and How to sort ADO.net DataTable and get and set latest FTP File Path in a variable […]

SSIS SFTP task examples to upload, download, move and delete files / folders

Introduction – Using SSIS SFTP task (FTP, SFTP, FTPS) In this article, we will show SSIS SFTP task examples. This task supports multiple protocols (Classic FTP, SFTP, FTPS). Uploading files using SFTP or downloading files are common requirements in SSIS. In order to work with FTP, Microsoft SSIS includes the FTP Task that allows to […]

Using Regular Expressions in SSIS

Introduction In this short article you will learn how to write Regular expressions in SSIS (i.e. Regex) and what tool to use to test them. You will also find helpful resources on how to write more sophisticated expressions and learn more about them. For demo purpose we will use FREEÂ SSIS Regex Parser TaskÂ to parse and […]

Articles/Posts

Click here to learn more about System Requirements

Download View All Tasks Like This