SSIS Excel File Source Connector

SSIS Excel File Source Connector

SSIS Excel File Source Connector (Advanced Excel Source) can be used to read Excel files with out installing any Microsoft Office Driver. You can extract using Table mode or query mode (SQL Command).

Features

  • Support for reading Excel Workbook using Table mode or SQL Query mode
  • Support for Office 2007 Excel files (*.XLSX) means you can read more than 64000 rows
  • Support for 64-bit mode without any additional driver unlike native SSIS Excel Connector
  • Support for outputting data in raw or formatted mode
  • Support for flexible metadata detection mode so you can get accurate datatypes
  • Support for Password protected workbooks
  • 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 Excel
See also
Custom SSIS Components - Excel File Destination Excel File Destination
Custom SSIS Tasks - Export Excel File Task Export Excel File Task
Custom SSIS Components - JSON Source (File and REST API Connector) JSON Source Connector (File, REST API)
Custom SSIS Components - CSV File Source (For Flat File and Web API) CSV Source (Flat File/ Web API)
Custom SSIS Components - Secure FTP Excel File Destination Secure FTP Excel File Destination
Custom SSIS Components - Azure Blob CSV File Source Azure Blob CSV File Source
Custom SSIS Components - Amazon S3 CSV File Source Amazon S3 CSV File Source
Download Help File Buy View All Tasks
ScreenshotsArticles / Useful LinksSystem Requirements

SSIS Excel Connection – Read/Write Office 2003/2007 Excel Formats

SSIS Excel Connection

Excel connection to read one excel file

SSIS Excel File Source – Read a sheet with different options

Excel source select table

Different ways to read a sheet.

SSIS Excel File Source – Read from Excel File using Table Mode

SSIS Excel File Source – Read from Excel File using Table Mode

Read the second sheet from the excel file with Table Mode

SSIS Excel File Source – Read from Excel File using SQL Query Mode

SSIS Excel File Source – Read from Excel File using SQL Query Mode

Read from Excel File using SQL Query Mode and variables

Articles / Tutorials

Click here to see all articles for [SSIS Excel Source] category


SSIS PowerPack v2.9.5 released (Maintenance Release)

SSIS PowerPack v2.9.5 released (Maintenance Release)

What’s New In this release we focused on fixing some bugs with Dynamics CRM Source , Dynamics CRM Destination and Reporting Services Task. Version 2.9.6.10621 [Jun 24, 2019] New Features/Improvements NEW: Excel Source – Add option to read from any sheet by number rather than hard coded table name (e.g. $4$ , $5$ … ) Bug fixes […]


Load data into PostgreSQL from Excel file using SSIS

Load data into PostgreSQL from Excel file using SSIS

Introduction In this post, we will learn How to Load data into PostgreSQL from Excel file using SSIS PostgreSQL Destination.  We will use SSIS PowerPack to connect PostgreSQL. This article also covers how to read Excel file in SSIS. SSIS PostgreSQL Destination can be used to perform bulk insert in PostgreSQL Table from any data source using SSIS. […]


How to read excel file in SSIS – Load into SQL Server

How to read excel file in SSIS – Load into SQL Server

Introduction In this post, we will learn How to read excel file in SSIS – Load into SQL Server.  We will use SSIS PowerPack to connect Excel file. This article also covers how to read Excel file in SSIS. SSIS Excel File Source Connector (Advanced Excel Source) can be used to read Excel files without installing any […]


SSIS PowerPack v2.9.2 released (Maintenance Release)

SSIS PowerPack v2.9.2 released (Maintenance Release)

What’s New In this release we focused on mainly focused on fixing high priority bugs related to Upsert Destination. We also added High DPI Monitor Support with Auto Scale UI option (4K Resolution now supported) Full Notes: https://zappysys.com/onlinehelp/ssis-powerpack/scr/release-notes.htm Version 2.9.2.10321 [Mar 21, 2019] New Features/Improvements NEW: Excel Source – Add Option to read first sheet and […]

Articles/Posts

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