MS Excel SSIS components 32/64 bit - COZYROC SSIS Suite

SSIS Excel file connection, Source and Destination Components

Introducing the COZYROC SSIS+ library with support for integration and migration of Microsoft Excel worksheet data. The Excel components are third-party plug-ins for Microsoft SSIS. Available on the market since 2010, COZYROC makes it easy to integrate or migrate data to and from Excel worksheets.

• The COZYROC components support Excel versions 1997 – 2019
• Support 32 and 64 bit execution.
• Support password-protected workbooks.
• No need to install any other component or Microsoft frameworks.

You can use any application, service or database supported by SQL Server Integration Services (SSIS) or COZYROC’s toolkit as the source or destination for Excel.

The toolkit is easy to use and follows the same guidelines and principles used by the standard out-of-the-box SSIS components. In addition, COZYROC also provides short and informative demonstration videos, providing step-by-step instructions on how to get started.

COZYROC's adapters are not dependent on any Microsoft modules or Office and, therefore, the adapters do not have the same limitations as the adapters provided by Microsoft.

The Excel SSIS integration package consists of four main parts:

Excel Connection Manager - Stores the credentials and functionality for connecting to Excel workbooks, whether they are on-premise or on Excel Mobile.

• Well documented API for use by user-defined scripts.

Excel Source component - Retrieves data from an Excel worksheet.

• The source workbook and worksheet can be dynamically modified at runtime using an SSIS expression.
• The standard Excel component only executes in 32-bit mode. The COZYROC component executes in both 32-bit and 64-bit modes.
• The standard Excel component tries to assign a data type for the columns (number, string, etc.) and sometimes gets it wrong, causing your package execution to fail. COZYROC’s component does not try to guess the data type and, therefore, handles mixed text and numbers in the same column without any problem.
• The standard Excel component requires you to use a SQL-like language to specify the columns and rows you want processed. COZYROC provides a point-and-click interface to specify this.
• To change the metadata of the input columns when using the standard Excel component, the use of a data conversion or derived column transformation is needed. COZYROC’s component allows the metadata to be changed in the component using the advanced editor.

Excel Destination component - Inserts data into an Excel worksheet.

• Supports three actions relative to existing data in the worksheet: Clear, Overwrite or Append.
• The destination workbook and worksheet can be dynamically modified at runtime using an SSIS expression.
• Provides information about rows with errors.
• The standard Excel component only executes in 32-bit mode. The COZYROC component executes in both 32-bit and 64-bit modes.

Excel Task – can be used to manage Excel workbooks. The task provides the following capabilities:

• Load from stream
• Save to stream
• Get worksheets list
• New worksheet
• Rename worksheet
• Delete worksheet
• Clear worksheet
• Delete Columns
• Delete Rows
• Find cell
• Replace cell
• Set password
• Set worksheet visible

Free for download and development within Visual Studio

✔️ Free developer license.

✔️ Support for SQL Server 2005 - 2022

✔️ COZYROC SSIS+ suite includes more than 270 tasks and SSIS components for ETL and Data Integration

✔️ A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud

✔️ One-time migrations and data transfers are completely FREE.

The COZYROC SSIS+ components suite also includes:

The powerful and elegant Data Flow Task Plus, not found in any other competitive product on the market. Data Flow Task Plus allows creation of Dynamic data flows at runtime and can be used with COZYROC's REST adapters.

Check the SSIS Data Flow Task demo video in our Youtube channel.

See also:

• COZYROC SSIS REST framework video. With the COZYROC SSIS REST framework you can connect to any Web service and consume any Web API. Free for download and development https://www.cozyroc.com/ssis/rest

• COZYROC SORT Plus SSIS component video. With COZYROC’s Sort Plus SSIS component, you can sort ANY amount of data and any number of records. Free for download and development https://www.cozyroc.com/ssis/sort

• For a full compatibility list and more information about the COZYROC SSIS+ Components, please visit the COZYROC website

Try COZYROC Cloud for free. The COZYROC.Cloud hosted service allows you to Lift & Shift legacy SSIS workloads to the cloud in a breeze at a very affordable price which includes a license for the COZYROC SSIS+ suite.

Get in touch with us:

• For support or any questions connect with us