Comprehensive suite of 200+ components for developing rock solid ETL solutions with Microsoft SQL Server Integration Services.
Work with SAS system data set files within MS Excel.
Script task to refresh Excel connections and pivot tables.
The script has the following parameters:
Script task to get Analysis Services object property.
This script task can decompress data compressed with the unix "compress" utility (LZC, a LZW variant). This code is based heavily on the unlzw.c code in gzip-1.2.4 (written by Peter Jannesen) and the original compress code.
A sample demonstrating SSIS script initialization setup with parameters provided by COZYROC SSIS+ library.
Script task providing management functions for IMAP email server.
Script task to retrieve environment variable.
The result is stored in specified ResultVariable package variable.
Script task demonstrating FTP over SSL (FTPS) use.
Script task to extract field information from IDataRecord object into SSIS variables. The variable names have to match the field names.
The task has the following parameters:
Script task to get files list.
Script task to manage IMailInfo list.