The Premium Excel components support working with both 32-bit and 64-bit runtimes as well as offering greater features and flexibility, and, do not require Microsoft Office or any additional drivers to be installed.

The Premium Excel components can create a new Excel file/sheet without code and allows for reading/writing from/to Excel files stored in:

  • FTPS
  • SFTP
  • Amazon S3
  • Azure Blob Storage
  • Box
  • Dropbox
  • Microsoft OneDrive, and,
  • Microsoft SharePoint*.

Additionally, the components support password-protected files and multiple write-mode options. The Premium Excel components can specify the exact row to retrieve or write data to and can output or retrieve data with or without format.

The Premium Excel components, part of the SSIS Productivity Pack, offer greater features and flexibility on your ETL projects.

SSIS Premium Excel

2020 Release Wave 1

Latest Updates & Features

Premium Excel Source/Destination components support working with worksheet index.

We added an "Ignore Cast Exception" option in Premium Excel Source columns, which can be used to prevent the component from failing should an InvalidCastException occur.

Premium Excel: data integration made easy

Our solution is easy to use, offering code-less integration between the Premium Excel components and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.

Our Premium Excel component is available within the Premium Data Flow components of our SSIS Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Premium Excel with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.


Other Premium Data Flow Components

Our Premium Data Flow components make it easy to integrate with different services within the ETL process. Each component available has been specifically developed to expand and enhance data migration and integration processes. In addition to Premium Excel, the Premium Data Flow components include: