MS Excel SSIS integration and migration - Cozyroc SSIS Library

COZYROC

|
714 clicks
| (0) | Free
Integration and migration of Microsoft Excel worksheet data. The COZYROC components support Excel versions 1997 – 2016. You can use any application, service or database supported by SQL Server Integration Services (SSIS) or COZYROC’s toolkit as the source or destination.

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 – 2016. 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 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.

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

Support for SQL Server 2005, 2008, 2012, 2014, 2016, 2017

Get in touch with us:

  • For support or any questions connect with us or email us at: support@cozyroc.com