Premium Excel SSIS components that support both 32 and 64-bit runtimes with greater flexibility when reading and writing to an Excel file.
SSIS Productivity Pack is a large collection of premium and unique SSIS components to help make SSIS more powerful and a developer's job easier. The collection contains 3 enhanced Excel components to offer developers greater flexibility when working with Excel data in SSIS
The following are the 3 components available within the SSIS Productivity Pack to help facilitate working with Excel data:
Excel Connection Manager
Connects to local Excel files and supports password encrypted files.
Premium Excel Source Component
An enhanced Excel source that supports both 32 and 64-bit runtimes. This premium components allows developers greater flexibility with the excel file set-up with support for specifying which row you want to start reading data from, how many rows you would like to retrieve and more.
Premium Excel Destination Component
An enhanced Excel destination component that supports both 32 and 64-bit runtimes. This premium component gives developers great flexibility in how data should be written to the excel file such as writing new data, overwriting existing data, adding to the end, or writing to specific rows as well as many other additional features.