Skip to content
| Marketplace
Sign in
Visual Studio>Controls>SSIS Secure FTP Source for JSON File
SSIS Secure FTP Source for JSON File

SSIS Secure FTP Source for JSON File

ZappySys

|
79 clicks
| (0) | Free Trial
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 compress
Get Started
ZappySys Logo 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 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 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 2012, 2014, 2016, 2017 and 2019 (32 bit / 64 bit)
  • Click here to see Secure FTP related articles
  • Click here to see JSON related articles
  • Click here to read more about SSIS Secure FTP Source for JSON File

    Screenshots

    SSIS Secure FTP JSON File Source – Create Azure Storage Connection SSIS Secure FTP JSON File Source – Select JSON File(s) using Blob Browser UI

    ZappySys SSIS PowerPack 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
    • Compatible with SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016 and 2017
    • Support for 32bit and 64bit Server/Desktop OS
    • 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

    • File Formats
      • JSON
      • XML
      • CSV
      • Excel
    • Microsoft Azure Cloud
    • Amazon AWS Cloud
    • SOAP / REST API
    • Secure FTP
    • Big Data / NoSQL (MongoDB, DynamoDB, Redshift...)
    • 3rd Party Online Services
    • Email and Reporting
    • Salesforce
    • Microsoft Dynamics CRM
    • Everyday things (Tasks to speedup common scenarios)
    JSON / API Integration
    Custom SSIS Tasks - Export JSON File Task Export JSON File Task Custom SSIS Tasks - JSON Source Connector (SOAP, REST, FILE) JSON File/REST API Source Custom SSIS Tasks - JSON Parser Task JSON Parser Task
    Custom SSIS Tasks - JSON Generator Transform JSON Generator Transform Custom SSIS Tasks - JSON Parser Transform JSON Parser Transform Custom SSIS Tasks - JSON File Destination JSON File Destination
    Custom SSIS Components - Azure Blob Source for JSON File Azure Blob Source for JSON File Custom SSIS Components - Amazon S3 Source for JSON File Amazon S3 Source for JSON File Custom SSIS Components - Secure FTP Source for JSON File Secure FTP Source for JSON File
    XML Integration
    Custom SSIS Tasks - Export XML File Task Export XML File Task Custom SSIS Tasks - XML Source Connector (SOAP, REST, FILE) XML File Source Custom SSIS Tasks - XML Parser Task XML Parser Task
    Custom SSIS Tasks - XML Generator Transform XML Generator Transform Custom SSIS Tasks - XML Parser Transform XML Parser Transform SSIS XML Destination Connector (Create XML file) XML Destination
    Custom SSIS Components - Azure Blob Source for XML File Azure Blob Source for XML File Custom SSIS Components - Amazon S3 Source for XML File Amazon S3 Source for XML File Custom SSIS Components - Secure FTP Source for XML File Secure FTP Source for XML File
    CSV / Flat File Integration
    Custom SSIS Components - Azure Blob Source for CSV File Azure Blob Source for CSV File Custom SSIS Components - Amazon S3 Source for CSV File Amazon S3 Source for CSV File Custom SSIS Components - Secure FTP Source for CSV File Secure FTP Source for CSV File
    Custom SSIS Components - Azure Blob Destination for CSV File Azure Blob Destination for CSV File Custom SSIS Components - Amazon S3 Destination for CSV File Amazon S3 Destination for CSV File Custom SSIS Components - Secure FTP Destination for CSV File Secure FTP Destination for CSV File
    Custom SSIS Components - CSV File Source CSV Source (File / Web API) Custom SSIS Tasks - CSV Destination CSV Destination Custom SSIS Components - CSV Parser Transform CSV Parser Transform
    Custom SSIS Tasks - CSV Generator Transform CSV Generator Transform Custom SSIS Tasks - CSV Generator Transform Export CSV File Task
    Excel Integration
    Custom SSIS Excel File Source Excel Source Custom SSIS Excel File Destination Excel Destination Custom SSIS Tasks - Export Excel File Task Export Excel File Task
    Microsoft Azure Cloud Integration
    Custom SSIS Tasks - Azure Blob Storage Task Azure Blob Storage Task Custom SSIS Components - Azure Table Storage Source Azure Table Storage Source Custom SSIS Components - Azure Table Storage Destination Azure Table Storage Destination
    Custom SSIS Components - Azure Queue Source Azure Queue Storage Source Custom SSIS Components - Azure Queue Destination Azure Queue Storage Destination Custom SSIS Components - Azure Blob Source for XML File Azure Blob Source for XML File
    Custom SSIS Components - Azure Blob Source for JSON File Azure Blob Source for JSON File Custom SSIS Components - Azure Blob Source for CSV File Azure Blob Source for CSV File Custom SSIS Components - Azure Blob Destination for CSV File Azure Blob Destination for CSV File
    Amazon AWS Cloud Integration
    Custom SSIS Tasks - Amazon S3 Task Amazon S3 Task Custom SSIS Tasks - Amazon Redshift Data Transfer Task Amazon Redshift Data Transfer Task Custom SSIS Tasks - Amazon Redshift ExecuteSql Task Amazon Redshift ExecuteSql Task
    Custom SSIS Tasks - Amazon Redshift Cluster Management Task Amazon Redshift Cluster Management Task Custom SSIS Components - Amazon DynamoDB Source Connector Amazon DynamoDB Source Custom SSIS Components - Amazon DynamoDB Destination Connector Amazon DynamoDB Destination
    Custom SSIS Components - Amazon Redshift Source Amazon Redshift Source Custom SSIS Components - Amazon Redshift destination Amazon Redshift Destination Custom SSIS Components - SSIS Amazon SQS SourceAmazon SQS Queue Source
    Custom SSIS Components - SSIS Amazon SQS Source Amazon SQS Queue Destination Custom SSIS Components - Amazon S3 Source for CSV File Amazon S3 Source for CSV File Custom SSIS Components - Amazon S3 Destination for CSV File Amazon S3 Destination for CSV File
    Custom SSIS Components - Amazon S3 Source for XML File Amazon S3 Source for XML File Custom SSIS Components - Amazon S3 Source for JSON File Amazon S3 Source for JSON File Custom SSIS Components - Amazon AWS API Connection Amazon API Connection (Lambda, EC2, Glacier, SQS and more)
    REST API, SOAP, Web API Integration
    Custom SSIS Components - JSON Source (File and REST API Connector) JSON Source Connector (File, REST API) Custom SSIS Components - XML Source Connector (SOAP, REST, FILE) XML Source Connector (File, SOAP, REST API) Custom SSIS Tasks - Call REST API Task REST API Task
    Custom SSIS Task - Export JSON File Task Export JSON File Task Custom SSIS Task - JSON Parser Task JSON Parser Task Custom SSIS Transform - JSON Generator Transform JSON Generator Transform
    Custom SSIS Task - Web API Destination Web API Destination
    Secure FTP Integration
    Custom SSIS Tasks - SSIS SFTP Task - FTP, FTPS, Secure FTPSFTP Task (FTP,FTPS,Secure FTP) Custom SSIS Components - Secure FTP Source for JSON File Secure FTP Source for JSON File Custom SSIS Components - Secure FTP Source for XML File Secure FTP Source for XML File
    Custom SSIS Components - Secure FTP Source for CSV File Secure FTP Source for CSV File Custom SSIS Components - Secure FTP Destination for CSV File Secure FTP Destination for CSV File
    Big Data / NoSQL Integration
    Custom SSIS Components - MongoDB Source Connector MongoDB Source Connector Custom SSIS Components - MongoDB Destination Connector MongoDB Destination Connector Custom SSIS Tasks - MongoDB ExecuteSQL Task MongoDB ExecuteSQL Task
    Custom SSIS Tasks - Amazon Redshift Data Transfer Task Amazon Redshift Data Transfer Task Custom SSIS Tasks - Amazon Redshift Cluster Management Task Amazon Redshift Cluster Management Task Custom SSIS Tasks - Amazon Redshift ExecuteSql Task Amazon Redshift ExecuteSql Task
    Custom SSIS Components - Amazon DynamoDB Source Connector Amazon DynamoDB Source Custom SSIS Components - Amazon DynamoDB Destination Connector Amazon DynamoDB Destination Custom SSIS Tasks - Amazon DynamoDB ExecuteSQL Task Amazon DynamoDB ExecuteSQL Task
    Custom SSIS Components - Amazon Redshift Source Amazon Redshift Source Custom SSIS Components - Azure Table Storage Source Azure Table Storage Source Custom SSIS Components - Azure Table Storage Destination Azure Table Storage Destination
    Custom SSIS Components - Amazon Redshift destination Amazon Redshift Destination
     
    Salesforce Connectivity
    Custom SSIS Components - Salesforce Source (Read/Query Data) Salesforce Source Connector Custom SSIS Components - Salesforce Destination (Bulk Insert, Update, Delete, Upsert) Salesforce Destination Connector Custom SSIS Components - Salesforce API Task (Call REST/SOAP API) Salesforce API Task (Call REST/SOAP API)
    PostgreSQL
    Custom SSIS Components - PostgreSQL Source (Read/Query Data) PostgreSQL Source Connector Custom SSIS Components - PostgreSQL Destination Connector PostgreSQL Destination Connector Custom SSIS Components - Salesforce API Task (Call REST/SOAP API) PostgreSQL ExecuteSQL Task
    Microsoft Dynamics CRM (CRM Online 365 / On-Premises)
    Custom SSIS Components - Microsoft Dyanmics CRM Source (Read/Extract Data) Dynamics CRM Source Connector Custom SSIS Components - Microsoft Dyanmics CRM Destination (Bulk Insert, Update, Delete, Upsert) Dynamics CRM Destination Connector
    3rd Party Online Services (REST/SOAP API Connectivity)
    Custom SSIS Components - Google Analytics Source Connector Google Analytics Source SSIS Google AdWords Connector - JSON/REST API Google Adwords API Integration SSIS Google Map API IntegrationGoogle Map / Geocoding API Integration
    SSIS Google Drive File - SpreadSheet Export Google SpreadSheet API Integration SSIS Google DFP Integration (DoubleClick for Publisher)Google DFP API Integration SSIS Google SpreadSheet API IntegrationGoogle SpreadSheet API Integration
    SSIS Google BigQuery API IntegrationGoogle BigQuery API Integration SSIS SurveyMonkey Connector - JSON/REST API SurveyMonkey API Integration SSIS HubSpot IntegrationHubSpot API Integration
    SSIS Amazon MWS (Marketplace Web Service) Amazon MWS API Integration (Marketplace Web Service) SSIS Amazon Athena API Integration (AWS)Amazon Athena API Integration SSIS Amazon AWS API Integration (EC2, Lambda, Gateway)Amazon AWS API Integration (EC2, Lambda, Gateway)
    SSIS Office 365 API Integration (Mail, OneDrive, Calendar, Excel, Contact)Office 365 API Integration (OneDrive, Calendar, Excel, Mail) SSIS Zendesk Connector Zendesk API Integration SSIS Twitter Connector Twitter API Integration
    SSIS ServiceNow API IntegrationLinkedIn API Integration SSIS Xero API IntegrationXero API Integration SSIS Zuora API IntegrationZuora API Integration
    SSIS Marketo Connector - JSON/REST API Marketo API Integration SSIS MailChimp Connector - JSON/REST API MailChimp API Integration SSIS QuickBooks Connector - JSON/REST API QuickBooks API Integration
    SSIS Workday Connector - XML/SOAP API WorkDay API Integration SSIS Facebook Graph API - JSON/REST APIFacebook Graph API Integration SSIS Zoho CRM API IntegrationZoho CRM API Integration
    SSIS Semantics3 Connector - XML/SOAP APISemantics3 API Integration SSIS eBay Connector - XML/SOAP API eBay API Integration SSIS SmartSheet API IntegrationSmartSheet API Integration
    SSIS NetSuite ConnectorNetSuite API Integration SSIS Salesforce Marketing API Integration (ExactTarget)Salesforce Marketing API Integration (ExactTarget) SSIS LinkedIn API IntegrationLinkedIn API Integration
    SSIS Zoom API IntegrationZoom API Integration SSIS TFS Online / VSTS (Visual Studio Online Team Services) ConnectorTFS API Integration (VSTS) SSIS ConstantContact API IntegrationConstantContact API Integration
    SSIS JIRA API IntegrationJIRA API Integration SSIS Azure API (Cognitive Services / Sentiment Analysis)Azure API Integration (Cognitive Services) SSIS Sharepoint API IntegrationSharepoint API Integration
    SSIS ExactOnline API IntegrationExactOnline API Integration SSIS Shopify API IntegrationShopify API Integration SSIS SAP S4/HANA API IntegrationSAP S4/HANA API Integration
    SSIS Oracle UCM Web Service API IntegrationOracle UCM API Integration SSIS Magento API IntegrationMagento API Integration SSIS Splunk API IntegrationSplunk API Integration
    SSIS ElasticSearch API IntegrationElasticSearch API Integration    
  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft