Ease SSIS Excel development, SSIS Premium Excel Components support working with both 32-bit and 64-bit runtimes as well as offering greater features and flexibility.

ssis export sql table to excel

  • Support for both 32-bit and 64-bit runtimes without any additional configurations.
  • Does not require Microsoft Office or any additional drivers to be installed.
  • Ability to create a new Excel file/sheet without code if it does not already exist when writing to Excel
  • Read/write to Excel files stored in the cloud as if they are local files.
  • Support for password protected files.
  • Option to specify the exact rows to retrieve or write data to.
  • Output data with or without format and option to retrieve formal.
  • Multiple write mode options available.

Our Premium Excel Components include:

Excel Connection Manager

Facilitates connection to local Excel files with support for password encrypted files. FTRS, SFTP, Amazon S3, Azure Blob Storage, Box, Dropbox, Microsoft OneDrive and Microsoft SharePoint Connection Managers may also be used to retrieve and/or write to Excel files stored in the cloud.

Premium Excel Source

An enhanced SSIS Excel source that supports 32 and 64-bit runtimes. This premium component allows developers greater flexibility with the excel file set-up with support for specifying which rows you would like to retrieve, field configuration, outputting formula, and more.

Premium Excel Destination

An enhanced SSIS Excel destination component the supports 32 and 64-bit runtimes. This premium component gives developers great flexibility in how data should be written to the excel file, configuring field formatting, as well as many other additional features.

The Premium Excel SSIS components are part of the SSIS Productivity Pack, a collection of premium and unique SSIS components designed to make a SSIS more powerful, and a developer's job easier. Read our blog on how to export data from SQL Server to Excel using SSIS.

SSIS Excel connection manager
SSIS premium Excel source
SSIS premium Excel source - columns
SSIS premium Excel destination
SSIS premium Excel destination - columns

Begin working with our Premium Excel and other SSIS components now

Download Premium Excel SSIS Components