Skip to content
ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence
ZappySys is a USA-based company with 10+ years in business and 3000+ customers in 90+ countries. Our mission is to provide user friendly, high performance drag-and-drop API Connectors, ODBC drivers, and no-code/low-code tools to automate data integration workflows and ensures maximum ROI.

Tel: +1-800-444-5602 | Live Chat

  • Home
  • Products
    • SSIS PowerPack
      • Product Overview
      • Compare Editions
      • Download FREE Trial
      • Documentation
      • Pricing
    • ODBC PowerPack
      • Product Overview
      • Compare Editions
      • Download FREE Trial
      • Documentation
      • Pricing
    • ZappyShell
    • ————————
    • Customer Download Area
  • Pricing
    • SSIS PowerPack
    • ODBC PowerPack
    • ZappyShell
  • API Integration
    • API Connectors / Apps
    • Articles
  • FREE SSIS Tasks
  • Blog
  • Community
  • Support
    • Contact Us
    • Product Documentation
    • Knowledge Base
    • FAQs
  • About Us
    • Our Customers
    • Our Partners
    • Resellers
    • Reviews & Testimonials
    • Privacy Policy
    • Terms & Conditions
  • Menu
Home » metadata

Tag Archives: metadata

Create new REST API Connection in SSIS (For JSON, XML or CSV Source)

How to read Salesforce Metadata in SSIS using REST API (JSON Source)

Updated on September 4, 2023 by ZappySys

Introduction In our previous posts we saw how to read and write Salesforce Data using SSIS. In this post we will see how to read Salesforce Metadata in SSIS using JSON Source. Step-By-Step In this section you will learn how to use ZappySys JSON Source Adapter to extract data from Salesforce REST API (JSON Format). You […]

Generate Metadata in ZappySys ODBC Drivers

Metadata in ODBC Driver / Performance Options

Updated on April 1, 2025 by ZappySys

Introduction In this post we will learn how to fix some metadata / performance related issues in ODBC PowerPack Drivers using Caching / Metadata / Streaming Mode features. By default ZappySys API Drivers issues atleast two API request (First one to obtain Metadata and second, third… for Fetching Data Pages). Most of the times this should […]

Handling SSIS Component Metadata Issues

Updated on October 27, 2017 by ZappySys

Introduction In this article you will learn how to edit SSIS Component Metadata and handle most common errors related to SSIS PowerPack Components. If you never heard about SSIS PowerPack then it’s addon pack to get additional 45+  SSIS components and Task (e.g. Connectivity to REST API, JSON, XML, Azure, AWS, Google, Salesforce etc).   […]

SSIS PowerPack - Collection of custom Tasks, Sources, Destination s and Transform
70+ high performance, drag and drop connectors/tasks for SSIS
Download Read More
ODBC PowerPack - Collection of ODBC Drivers for REST API, JSON, XML, SOAP, OData
ODBC Drivers for REST API, JSON, XML, SOAP, OData … Integrate inside Apps like Power BI, Tableau, SSRS, Excel, Informatica and more…
Download Read More

Recent Posts

  • Product release announcements have been moved to the Community Site
  • How to upload files on SharePoint Online using SSIS
  • How to download files from SharePoint Online using SSIS
  • How to download files from OneDrive using SSIS
  • How to upload files on OneDrive using SSIS

Categories

  • Announcements (44)
  • Cloud Computing (13)
    • AWS (Amazon Web Services) (12)
      • Redshift (5)
      • S3 (Simple Storage Service) (7)
  • Google API (14)
  • ODBC PowerPack (61)
    • ODBC App Integration (24)
      • ETL – Informatica (3)
      • ETL – Pentaho Kettle (1)
      • ETL – Talend (1)
      • Reporting – Google Sheet (1)
      • Reporting – Microsoft Access (4)
      • Reporting – Microsoft Excel (1)
      • Reporting – Microsoft Power BI (8)
      • Reporting – Microsoft SSRS (2)
      • Reporting – MicroStrategy (1)
      • Reporting – Qlik (1)
      • Reporting – Tableau (2)
    • ODBC Drivers (51)
      • Amazon S3 CSV Driver (2)
      • Amazon S3 JSON Driver (2)
      • Amazon S3 XML Driver (2)
      • API Driver (1)
      • Azure Blob CSV Driver (1)
      • Azure Blob JSON Driver (1)
      • Azure Blob XML Driver (1)
      • CSV File / REST API Driver (1)
      • JDBC Bridge Driver (1)
      • JSON File / REST API Driver (34)
      • Salesforce Driver (1)
      • XML File / SOAP API Driver (22)
    • ODBC Gateway (17)
    • ODBC Programming (14)
      • C# (CSharp) (2)
      • JAVA (1)
      • PHP (1)
      • PowerShell (1)
      • Python (2)
      • T-SQL (SQL Server) (9)
  • REST API (37)
  • REST API Integration (66)
  • SSIS PowerPack (211)
    • SSIS Components (148)
      • REST Connector (3)
      • SSIS Amazon DynamoDB Destination (1)
      • SSIS Amazon DynamoDB Src (1)
      • SSIS Amazon Redshift Destination (1)
      • SSIS Amazon Redshift Source (1)
      • SSIS Amazon S3 CSV Dest (1)
      • SSIS Amazon S3 CSV Source (2)
      • SSIS Amazon S3 JSON Source (2)
      • SSIS Amazon S3 XML Source (1)
      • SSIS Amazon SQS Destination (1)
      • SSIS Amazon SQS Source (1)
      • SSIS API Destination (1)
      • SSIS API Source (6)
      • SSIS Azure Blob CSV Destination (1)
      • SSIS Azure Blob CSV Source (1)
      • SSIS Azure Blob JSON Source (1)
      • SSIS Azure Blob XML Source (1)
      • SSIS Azure Queue Storage Destination (2)
      • SSIS Azure Queue Storage Source (2)
      • SSIS Azure Table Storage Destination (1)
      • SSIS Azure Table Storage Source (1)
      • SSIS Conditional Split Transform (1)
      • SSIS CSV File Destination (2)
      • SSIS CSV Generator Transform (2)
      • SSIS CSV Parser Transform (1)
      • SSIS CSV Source (6)
      • SSIS Dummy Data Source (1)
      • SSIS Dynamics CRM Destination (3)
      • SSIS Dynamics CRM Source (3)
      • SSIS Excel Destination (2)
      • SSIS Excel Source (4)
      • SSIS Google Analytics Source (3)
      • SSIS HTML Table Source (2)
      • SSIS JSON File Destination (2)
      • SSIS JSON Generator Transform (8)
      • SSIS JSON Parser Transform (5)
      • SSIS JSON Source (File/REST) (62)
      • SSIS Merge Join Transform (1)
      • SSIS MongoDB Destination (3)
      • SSIS MongoDB Source (6)
      • SSIS PostgreSQL Destination (1)
      • SSIS PostgreSQL Source (2)
      • SSIS Recordset Destination (1)
      • SSIS Salesforce Destination (3)
      • SSIS Salesforce Source (4)
      • SSIS Script Component (1)
      • SSIS Set Variable Transform (1)
      • SSIS SFTP CSV Source (1)
      • SSIS SFTP JSON Source (1)
      • SSIS SFTP XML Source (1)
      • SSIS Sort Transform (1)
      • SSIS Template Transform (12)
      • SSIS Trash Destination (3)
      • SSIS Upsert Destination (7)
      • SSIS WEB API Destination (13)
      • SSIS XML File Destination (1)
      • SSIS XML Generator Transform (4)
      • SSIS XML Parser Transform (3)
      • SSIS XML Source (File / SOAP) (20)
    • SSIS Connection Manager (41)
      • HTTP Connection (6)
      • SSIS Amazon S3 Connection (3)
      • SSIS Azure Blob Connection (4)
      • SSIS Dynamics CRM Connection (1)
      • SSIS Excel Connection (2)
      • SSIS MongoDB Connection (1)
      • SSIS OAuth Connection (14)
      • SSIS PostgreSql Connection (4)
      • SSIS Salesforce Connection (4)
      • SSIS SFTP / FTP Connection (2)
    • SSIS Tasks (87)
      • SSIS Advanced File System Task (10)
      • SSIS Amazon DynamoDB ExecuteSQL Task (1)
      • SSIS Amazon Redshift ExecuteSQL Task (1)
      • SSIS Amazon Storage Task (10)
      • SSIS Azure Blob Storage Task (9)
      • SSIS CSV Export Task (6)
      • SSIS Download File Task (1)
      • SSIS Excel Export Task (3)
      • SSIS ForEach Loop Task (1)
      • SSIS JSON Export Task (2)
      • SSIS JSON Parser Task (2)
      • SSIS Logging Task (7)
      • SSIS MongoDB ExecuteSQL (4)
      • SSIS PostgreSQL ExecuteSQL Task (1)
      • SSIS Regex Parser Task (4)
      • SSIS Report Generator (SSRS) (1)
      • SSIS REST API Task (36)
      • SSIS Salesforce API Task (1)
      • SSIS SFTP Task (6)
      • SSIS Timer Task (1)
      • SSIS XML Export Task (2)
      • SSIS Zip File Task (1)
  • SSIS Tips & How-Tos (15)
  • Tools (3)
  • Uncategorized (10)
  • ZappyShell (1)

Tags

access amazon api API Integration aws azure CSV Destination excel export fiddler google google api json json source MongoDB oauth oauth2 odata odbc office 365 pagination PostgreSQL power bi redshift regex Regular Expression rest rest api s3 salesforce soap source SQL sql server ssis ssis advanced file system task SSIS JSON Generator Transform ssis json source SSIS PowerPack ssis rest api task ssis xml source storage upsert xml

Sitemap

  • Home
  • Products
  • Purchase
  • Product Documentation
  • Contact us
  • Privacy Policy
  • Terms & Conditions
  • Support

Follow us

RSS ZappySys Community – Latest topics

  • SSIS Tips: How to Schedule Your Packages Effectively
  • SSIS Tip: Extracting JSON Data Stored in SQL Server Tables
  • SSIS Tutorial: Converting Excel to PDF using Adobe APIs
  • SSIS tips: How to import JSON files to MongoDB
  • SSIS Tip: How to import JSON files into SQL Server
  • How to set default AWS credentials in SSIS or ODBC application
  • How to Fix the “This App is Blocked” Error in Google OAuth
  • SSIS tips: How to delete old files easily from SFTP
  • How to copy files with specific extensions using SSIS
  • How to move old files and compress them using SSIS (archiving files)
All rights reserved ZappySys LLC.
A SiteOrigin Theme