Project Description
This is a community project for developing additional tasks and components for SSIS, and identifying other CodePlex projects that do the same. 47 Integration Services extensibility projects exist on CodePlex - find them and almost a hundred more from around the 'net right here.
This list includes projects hosted on CodePlex, items that are available in source or binary-only form for free on other sites, or are commercially available items from third party companies. If there are errors in this list, please contact me directly, or post in the Discussions.

Tools

BIDSHelper - Extends BIDS (Business Intelligence Development Studio, aka Visual Studio for SQL BI) with lots of useful visual cues and functionality.
DTLoggedExec - Replaces DTExec with an execution tool that can be easily configured to log package behaviour and profile package performance.
MetaShare - Manages Data Warehouse metadata by analyzing SSIS packages.
Package Explorer - A Visual Studio add-in to replace Solution Explorer, allowing subfolders.
Package Manager - A utility designed to permit batch operations on arbitrary sets of SSIS packages. Users can select a single package, a Visual Studio project or solution or a file system folder tree and then validate or update all...
Metadata Driven ETL Management Studio - Originally an internal MSIT solution that has been released as an open source project, the Microsoft SQL Server Metadata-Driven ETL Management Studio (a.k.a. MDDE) provides a tool for rapidly generating SQL Server Integration Services (SSIS) packages from a shared central metadata repository.
Non Admin Access Tool - Make SSIS servers accessible to users who are not administrators on the SSIS machine.
SSIS Log Analyzer - This utility helps in analyzing SSIS logs and if possible provide cause and resolutions for issues found in it.
ssisUnit - A unit testing framework for SQL Server Integration Services.

Connection Managers

Amazon S3 Connection Manager - Establish connections with Amazon S3 service.
Excel2 Connection Manager - connects to an available Microsoft Excel workbook by using the OleDb .NET Framework Data Provider and the Microsoft OLE DB Provider for Jet.
FTPS Connection Manager - Establish FTP over SSL connections.
Jabber Connection Manager - Establish connections with Jabber/XMPP server.
Microsoft CRM - Allows exposure of Microsoft CRM web services as a Connection Manager.
Oracle - Connects to Oracle v9.2.0.4 and higher.
Package Connection Manager - Allows access to current or another package at runtime.
SalesForce.com - Establish Salesforce connections.
SAP BI - Connects to or from an SAP NetWeaver BI version 7.0 system.
SSH Connection Manager - Connects to an SSH-enabled server.
SQL Custom Connection Manager - Connects to an available instance of Microsoft SQL Server by using the SqlClient .NET Framework Data Provider.
SQL Server Data Services Connection Manager - A connection manager for SQL Server Data Services.
Teradata - Connects to Teradata Database version 2R6.0, 2R6.1, 2R6.2, 12.0 and higher.

Log Providers

Email Log Provider - Sends logging output as an e-mail message in either plain text or HTML format.
HTML Log Provider - Writes logging output to an HTML document.

Tasks (for Control Flow)

Amazon S3 - Send and receive files to Amazon S3 service.
Compress File - Compresses and decompresses files using System.IO.Compression.
Compression Task - Compresses or decompresses a file or directory.
Credit Card
Custom Logging - Writes logging information to a log table.
Data Flow Plus - Allows setup of dynamic data flows.
Database Partition - Create and maintain SQL Server partitions.
Download Mail - Downloads mail (plus attachments) from a POP3 server.
Dynamics GP eConnect
Dynamics GP Next Document Number
Execute SQL Job And Wait - Executes a SQL Agent job, and waits for it to complete.
File
FTP
File Properties Task - Reads the properties of a file and writes the values to a series of variables.
File Properties Task - Retrieves and optionally sets properties on a file. Available properties include file existence, size, read/write locks, creation/last access/last modification date, and file attributes.
File Watcher - The task will detect changes to existing files as well as new files, both actions will cause the file to be found when available.
Increment - A private integer variable is incremented on each iteration of the loop.
Jabber - Interacts with Jabber/XMPP clients.
OpenPGP - Encryption and decryption using OpenPGP (RFC 2440).
Pause Task - Pauses the Control Flow for a specified number of milliseconds, or until a specific time of day.
Report Generator Task - SSIS Task for SQL Server 2008 to create Reports from a recordset data source.
RSS
S3
Script Plus - An extension of the standard Script Task.
SCP - secure copying of files with SSH server.
SecureBlackBox PDF Processor
Secure Email
Secure FTP Task - Allows you to transmit files over most common secure channels.
Secure Shell (SSH)
Send HTML Mail Task - Sends email in plain-text or HTML format.
Set Variable - Set variables during Control Flow execution without resorting to a Script Task.
SFTP - Secure FTP communication.
SFTP
SMSTask - Sends SMS messages.
SMPP
SNPP
SSH Execute - secure execution of shell commands on a remote SSH server.
Stream - management and manipulation of standard Stream object.
String Concatenation
TaskUnZip - Manages compressed files (including password protected).
Template Task - Generate text documents like XML, EDI, HTML, CSV, etc.
TwitterTask - Custom Twitter Task with "Tweet" and "GetReplies" functionality.
XMPP
Zip - compression and decompression of Zip, GZip, BZip2, Unix (rfc1950) and Tar archives.
Zip

Foreach Enumerators

Directory - Iterates over directory names.

Script Task Script Samples

File Properties
FTP
Timer
Transform XML
Find and Replace
SQL Job Agent

Components (for Data Flow)

Sources

Active Directory Source - Extracts data from Active Directory into a relational format.
ADO Source - Uses the ADO.NET connection manager to acquire a connection to a database, and runs the SQL statement provided by the user.
Data Flow Source - Reads data into a data flow previously sent to a CozyRoc Data Flow Destination component.
Data Defractor
Data Generator - The Data Generator Source is now available for SQL Server 2005 and SQL Server 2008. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline.
Delimited File Reader Source - A source component capable of parsing delimited flat files, including files with rows that are missing column fields.
Delimited File Source - An extremely robust flat file source for Integration Services which handles quoted text and provides full data auditing. Based on the work of Microsoft's Bob Bojanic (Delimited File Reader Source Sample).
EBCDIC Source
EDI Source - parses EDI format files.
Image Source - Imports images as BLOBs (DT__IMAGE type) with various additional information such as EXIF data, GPS data, and other file information.
Regular Expression Flat File Source - A regular expression based flat file parsing source.
RegExSourceAdapter - Imports text files which are not properly formatted flat files by specifying a regular expression.
SalesForce - Consume data from SalesForce.com.
SharePoint List Source - Demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0.
SQL Server Data Services Source - A source for SQL Server Data Services.
Trace File - Allows you to read 2005 and 2008 profiler traces stored as .trc files and read them into the Data Flow.
WMI Source - Using WMI, you can retrieve and process all kinds of data about your system's performance using SSIS data flows.

Transforms

Address
Address Correction
Address Object Transform - CASS (Coding Accuracy Support System) Certified^TM component corrects, validates, and standardizes addresses against USPS® DPV® files.
Address Parse - Parses, corrects and standardizes United States addresses.
Address Standardization
Change Case - Changes the case of a character in a string by modifying a single character in the specified column as the rows pass through the component.
Checksum - Computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column.
Codepage Convert - Translates from and to any code page or unicode character representations.
Column Pattern Transform - Data profiling and monitoring.
Column Profiling - Data profiling and monitoring.
Credit Card Number Validator 05 - Determines whether the given input is a valid credit card number or not.
Data Validation Component - Verifies that your data is clean prior to insertion.
Dedupe
Distinct - Remove duplicates from the flow.
eLog - A custom component for recording error flow information.
Email Object Transform - Validate and correct misspelled or invalid email addresses.
Error Output Description - A component that takes error outputs from multiple data flow components, decoding the error code and column information into error descriptions and column names.
FlowSync - Makes two or more flows of data in a data flow run at the same speed.
Fuzzy Matching (Jaro, n-Gram) Transform - Fuzzy matching.
Fuzzy Matching (Jaro-Winkler) Transform - Fuzzy matching.
Fuzzy Matching (n-Gram) Transform - Fuzzy matching.
Geocoder Transform - Appends latitude and longitude coordinates, Census track and block numbers, and county name and FIPS code to the ZIP+4^TM level.
Kimball Method SCD - A transformation component that performs roughly the same work as the stock SCD component, but without a "wizard" creating multiple components on the design surface. Other differences include operating in a "fully cached" mode increasing performance, addition of auditing functions, surrogate key generation, and increased flexibility of comparisons.
Lookup Plus - enhanced functionality compared to the standard SSIS Lookup component.
MapPoint Batch Geocoder - Performs batch geocoding of address information directly within the SSIS pipeline using the geocoding capabilities of MapPoint's Customer Data Services.
Matchup Object Transform - Find and eliminate duplicate records.
Merge
Merge/Purge/Deduplication
Multiple Hash - SSIS Multiple Hash makes it possible to generate many Hash values from each input row. Hash's supported include MD5 and SHA1.
Name Object Transform - Parse the names in your database into 5 components: Prefix, First, Middle, or Initial, Last, and Suffix. Discover the gender makeup of your list and flag suspicious and vulgar names.
Name Parsing
Name Standardization
Normaliser - Separates a data flow from denormalized "repeated header plus details" rows into two separate "header" and "detail" outputs.
Normalization Transform - Generalized cleansing.
NSort
Null Detector - Depending on whether the value of a user-indicated column is null or not, routes rows to one or the other of its outputs.
Phone
Phone Object Transform - Reduce data entry errors while updating and correcting any U.S. or Canadian area code and prefix combination.
RegexClean - Use the power of regular expressions to cleanse your data right there inside the Data Flow.
Regex - Applies a configured regular expression against an incoming column, matching, extracting, or splitting, as configured by the user.
Regular Expression - Exposes the power of regular expression matching within the pipeline.
Remove Duplicates - Distinct rows are sent to one output and the duplicate rows to the other.
Row Count Plus - A simpler UI, and the ability to calculate durations between Row Count Plus transformations.
Row Number - calculates a row number for each row, and adds this as a new output column to the data flow.
RTrim Plus - Takes a string or unicode column, and removes trailing spaces, whether ASCII, or Japanese.
Script Component Plus - An extension of the standard Script Component.
SeeBuffer - Sits in a data flow and is provided a look at each buffer that is presented to it.
SmartMover Transform - NCOA^Link process your mailing list.
SortDeDuplicateDelimitedString - This synchronous component transforms a column that contains a delimited string, sorts the delimited values, and removes any duplicate values from the delimited string.
SpatialGrid - Replicating rows with SqlGeometry data by cutting geometry object in pieces on a given grid.
SpatialUnion - Aggregation of spatial data grouped by a regular column. The sample is simplified by requiring a sorted group by column.
TableDifference - Simplify the management of slowly changing dimensions and – in general – to check the differences between two tables or data flow with SSIS.
UnDouble - Removes bracketing quotes if present, plus replaces double quotes inside the text with single quotes.
UnDoubleOut - Removes qualifiers from quoted text, either in place, or via the creation of a new output column.
Unpack Decimal - Takes an input column formatted in packed decimal (comp-3), and generates the corresponding Decimal value.
UnPivotDelimitedString - This asynchronous component takes a column with a delimited string and un-pivots the information, outputting a row for each delimited value that contains the original delimited string, one of the delimited values, and the position of the delimited value in the string. The value of the delimiter is included as the custom property DelimiterString and can be set at design time.
Validation and Cleansing Transform - Generalized cleansing.
Value Distribution - Data profiling and monitoring.
VectorTransformations - Applying series of transformations (translations, rotations and scaling), defined using simple expressions, on geometry objects contained in a SqlGeometry column.
Xmlify - Takes a series of columns and turns them into a single XML column.

Destinations

Batch Destination - A destination component that allows you to perform set based UPDATEs inside the data flow, and manages the creation and deletion of temporary tables to support the set based operation.
Data Flow Destination - Stores a rowset for subsequent use in a CozyRoc Data Flow Source component.
Dataset Destination - stores the rows it receives during execution in a dataset. At the end of execution, depending on the configuration of the component, the dataset is assigned to a run-time variable and may also be saved to an XML file.
DB2 Destination - connects to DB2 database and bulk loads data into DB2 database tables.
Informix Destination - connects to Informix database and bulk loads data into Informix database tables.
ODBC Destination - load data into ODBC-compatible database tables.
Oracle Bulk Load Connector
MERGE Destination - Combines ADO.NET's new table-valued parameter support, the new SQL MERGE statement, and SSIS together to create a powerful and fast component for performing MERGE operations against SQL Server.
Oracle Destination - connects to Oracle database and bulk loads data into Oracle tables.
SalesForce - Write data to SalesForce.com.
SharePoint List Destination - Demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0.
SQL Server Data Services Destination - A destination for SQL Server Data Services.
Trash Destination - Does nothing but consume rows with no setup requirement.
Upsert Destination - Reads the rows coming into the data flow and detects if the row should be inserted or updated.
XmlDestination - A simple XML Destination pipeline component.
XML Destination