SSIS Secure FTP JSON File Source Connector

SSIS Secure FTP Source for JSON File

SSIS Secure FTP Source for JSON File can be used to read JSON files from Secure FTP Storage. 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. *.json)
  • Support for FTP (Classic FTP), SFTP, FTPS or FTP/SSL Protocols
  • Support for Path expression to extract data from any level (e.g. Extract Orders nested under Customer Node).
  • Support for reading zip and gzip compressed files (stream mode)
  • Support for data pivot (transform columns into rows)
  • Support for Dynamic file path using variable placeholder (e.g. /myroot/{{User::MyFolder}}/*.json )
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Click here to see Secure FTP related articles
  • Click here to see JSON related articles
 SSIS Secure FTP JSON File Source Connector - Video Tutorial
See also
Custom SSIS Components - Secure FTP CSV File Destination Secure FTP CSV File Destination
Custom SSIS Components - Secure FTP JSON File Source Secure FTP JSON File Source
Custom SSIS Components - Secure FTP XML File Source Secure FTP XML File Source
Custom SSIS Tasks - Azure Table Storage Source Azure Table Storage Source
Custom SSIS Tasks - Amazon S3 Storage Task Amazon S3 Storage Task
Custom SSIS Components - JSON Source (File and REST API Connector) JSON Source Connector (File, REST API)
Download Help File Buy View All Tasks
ScreenshotsArticles / Useful LinksSystem Requirements

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

SSIS Secure FTP JSON File Source - Read from JSON File Options

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

SSIS Secure FTP JSON File Source – Create Azure Storage Connection

SSIS Secure FTP JSON File Source - Create Azure Storage Connection

SSIS Secure FTP JSON File Source – Create Azure Storage Connection

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

SSIS Secure FTP JSON File Source - Select JSON File(s) using Blob Browser UI

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

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

SSIS Secure FTP JSON File Source - Read Compressed JSON File (GZip or Zip)

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

SSIS Secure FTP JSON File Source – DateTime Parsing Options

SSIS Secure FTP JSON File Source - DateTime Parsing Options

SSIS Secure FTP JSON File Source – DateTime Parsing Options

SSIS Secure FTP JSON File Source – Design time data preview

SSIS Secure FTP JSON File Source - Design time data preview

SSIS Secure FTP JSON File Source – Design time data preview

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

SSIS Secure FTP JSON File Source - Redirect Bad Records (Error Handling)

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

Articles / Tutorials

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


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

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)

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)

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

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

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 […]

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