[MSSQL] SSIS Community Tasks and Components

SSIS 를 사용하다보면 기본적으로 사용하는 것들 이외에 추가적으로 필요한 것들이 있습니다. 
코드플렉스에 이런것들을 잘 모아 뒀군요 ^^

출처 : http://ssisctc.codeplex.com/

 Project Description
This is a community project for developing additional tasks and components for SSIS, and identifying other CodePlex projects that do the same. 51 Integration Services extensibility projects exist on CodePlex - find them and over 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 or ommissions in this list, please contact me directly, or post in the Discussions.

Tools

BI Monkey SSIS ETL Framework - The BI Monkey SSIS ETL Framework is an ETL Execution, Control and Logging system for ETL projects using SSIS.
BIDSHelper - Extends BIDS (Business Intelligence Development Studio, aka Visual Studio for SQL BI) with lots of useful visual cues and functionality.
DTExecRemote - Executes SSIS packages on remote servers via dynamic SQL Agent job creation.
DTLoggedExec - Replaces DTExec with an execution tool that can be easily configured to log package behaviour and profile package performance.
Expression Editor - A standalone app that allows expressions to be built and tested. Can also be used in custom object UIs for a better expression editing experience.
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 Downgrade - Downgrade an SSIS 2008 package to SSIS 2005.
SSIS-DTS Package Search - Search through SSIS & DTS packages for tables, columns, and property names.
SSIS Log Analyzer - This utility helps in analyzing SSIS logs and if possible provide cause and resolutions for issues found in it.
SSIS Reporting Pack - A suite of SSRS (Reporting Services) reports that operate on the SSIS catalog in SQL Server code-named Denali.
ssisUnit - A unit testing framework for SQL Server Integration Services.

Connection Managers

Amazon S3 Connection Manager - Establish connections with Amazon S3 service.
Dynamics CRM Connection Manager - Connect to Dynamics CRM service.
Excel Connection Manager - Connections to Microsoft Excel workbook files with support for 64bit machines.
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.
IMAP - Connection with IMAP mail server.
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.
POP3 - Connection with POP3 mail server.
SalesForce.com - Establish Salesforce connections.
SharePoint - Connections with SharePoint service.
SAP BI - Connects to or from an SAP NetWeaver BI version 7.0 system.
SMTP - Connections with SMTP mail server.
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.
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.
AS2 Receive - Allows SQL Server Integration Services packages to receive AS2 messages over the Internet.
AS2 Send - Allows SQL Server Integration Services packages to send AS2 messages over the Internet.
Certificate - The Certificate Component allows data to be validated or signed / encrypted based on X509 certificate security.
Compress File - Compresses and decompresses files using System.IO.Compression.
Compression Task - Compresses or decompresses a file or directory.
Convert - The Convert Component allows you to convert a message between EDI, Xml, HL/7, delimited, positional and binary formats.
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
Email - The Email Component allows you to receive and process POP3 emails.
Excel Task - Management of Microsoft Excel workbooks.
Execute Assembly - Executes a method from a given assembly file.
Execute SQL Job And Wait - Executes a SQL Agent job, and waits for it to complete.
File
File - The File Component allows you to locate, read and write files much more flexibly than under vanilla SQL Server Integration Services.
FTP
FTP - The FTP Component allows you to enumerate, read or write files via FTP, FTPS or SFTP. In addition to supporting secure FTP this component is much more flexible than the standard SSIS one.
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.
HL7 Ack - The HL7 ACK Component will automatically generate an acknowledgement message for an incoming HL7 v2.x message.
HTTP - The HTTP Component allows you to send and receive messages via HTTP or HTTPS.
Increment - A private integer variable is incremented on each iteration of the loop.
Jabber - Interacts with Jabber/XMPP clients.
Log Variables - The Log Variables Component allows you to dump the current state of the package variables to the Windows event log.
MLLP Receive - The MLLP Receive Component allows you to receive MLLP messages via TCP. MLLP is typically used for HL/7 messages.
MLLP Respond - The MLLP Respond Component allows you to send a response for an incoming MLLP message.
MLLP Send - The MLLP Send Component allows you to send an MLLP message.
OLEDB Bridge - The OLEDB Bridge Component allows you to use a common connection for components requiring both OLEDB and ADO.Net connections.
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.
Powershell Task - Call and execute PowerShell scripts directly from within SQL Server Integration Services.
Receive Mail Task Plus - Receive emails with support for security.
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. Sometimes used with the HTML Table Destination.
Send Mail Task Plus - Enhanced task for sending emails with support for security.
Set Variable - Set variables during Control Flow execution without resorting to a Script Task.
SFTP - Secure FTP communication.
SFTP
Simple Transaction Begin - The Simple Transaction Begin allows you to manage database transactions across individual connections without the use of DTC.
Simple Transaction Commit - The Simple Transaction Commit allows you to manage database transactions across individual connections without the use of DTC.
Simple Transaction Rollback - The Simple Transaction Rollback allows you to manage database transactions across individual connections without the use of DTC.
Sleep - The Sleep Component provides a simple way of sleeping for a given nyumber of milliseconds, for example in a polling scenario.
SMSTask - Sends SMS messages.
SMPP
SNPP
SQL Component - The SQL Component provides a strongly types intuitive and graphical way of inserting, updating, deleting, upserting or merging data, executing a stored procedure, or executing tokenised SQL.
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.
Web Service Call - The Web Service Call Component allows you to easily consume web services.
Web Service Receive - The Web Service Receive Component allows you to wait for and pick up incoming data from a web service.
Web Service Respond - The Web Service Respond Component allows you to return a response for a web service call.
XML Transform - The Xml Transform Component allows you to map from one Xml format to another via a sophisticated and flexible graphical mapping tool, and also enables you to convert between Xml and EDI, Xml, HL/7, delimited, positional or binary formats.
XMPP
Zip - compression and decompression of Zip, GZip, BZip2, Unix (rfc1950) and Tar archives.
Zip

Foreach Enumerators

Directory - Iterates over directory names.
File - File enumerator. 
FTP File - FTP File enumerator. 
AS2 Message - AS2 Message enumerator. 
Email Message - Email Message enumerator. 
MLLP Message - MLLP Message enumerator. 
Web Service Message - Web Service Message enumerator. 
Infinite Loop - Infinite loop enumerator. 
Loop Once - Loop once enumerator. 
SQL - SQL enumerator.

Script Task Script Samples

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

Components (for Data Flow)

Script Component Samples

XML Source
Row Numbering - Add a sequential number to each row.

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).
Dynamics CRM Source - Loads data from Dynamics CRM service.
EBCDIC Source
EDI Source - parses EDI format files.
Excel Source Plus - Load data from Microsoft Excel workbook.
Google Analytics Source - Load data from the Google Data API.
Image Source - Imports images as BLOBs (DT__IMAGE type) with various additional information such as EXIF data, GPS data, and other file information.
Microsoft CRM Source - The Microsoft CRM Source allows you to read data from Microsoft CRM versions 3.0 and beyond.
Microsoft Sharepoint Source - Allows you to read list data from Microsoft SharePoint 2007 and beyond.
Oracle - Achieve optimal performance when loading data out of Oracle.
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.
ShapeFile Source - Imports ESRI ShapeFiles and associated dbase files.
SharePoint Source - Load data from Microsoft SharePoint list.
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 - The SQL Component provides a strongly types intuitive and graphical way of inserting, updating, deleting, upserting or merging data, executing a stored procedure, or executing tokenised SQL.
Teradata - Achieve optimal performance when loading data out of Teradata.
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.
XML Source - The Xml Source Component allows you to expand Xml data into column data, where the originating Xml data comes from a data-flow column or a variable. This component also enables you to convert to Xml from EDI, Xml, HL/7, delimited, positional or binary formats.
XTract IS - Reads SAP reports and extracts data from them.

Transforms

Address - Validates, standardizes and geocodes addresses with reference data of more than 240 countries and territories.
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
Advanced Map - The Advanced Map Component allows you to define sophisticated data transformations graphically.
Aggregate Text - Aggregates multiple rows of text into one row.
Basic Map - The Basic Map Component allows you to define simple and flexible value mappings.
Balanced Data Distributor - Splits a data flow equally into multiple output flows in order to multithread downstream processing.
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.
Change Filter - The Change Filter Component efficiently compares the entire state of a data-flow with the state at the time it was last row, breaking down all changes into inserted, updated or deleted rows that can then be routed differently. This component can also be used to compare two separate databases.
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.
Commit Change Filter - The Commit Change Filter Component commits the current state of the data-flow as the reference source.
Credit Card Number Validator 05 - Determines whether the given input is a valid credit card number or not.
Cross Join - The Cross Join Component allows you to merge, correlate and manipulate data from multiple sources.
Currency - Converts amounts of money into different currencies with current and historical data information.
Data Validation Component - Verifies that your data is clean prior to insertion.
Dedupe - Quickly and successfully detects duplicates with unrivalled speed.
Deletix - Deletes duplicates based on different priority information and builds detailed processing logs.
Dimension Merge SCD - A transformation component that performs roughly the same work as the stock Slowly Changing Dimension 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.
Distinct - Remove duplicates from the flow.
eLog - A custom component for recording error flow information.
Email - Validates email addresses based on RFC 2822 and DNS queries.
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.
Expression - The Expression Component avoids the requirement to have to write opaque VSTA code to execute even the simplest bit of logic, enabling simple expressions relating to tasks such as incrementing a variable or formatting a date to be written easily. Expressions can reference variables, columns and .Net Framework code, and the result can be stored in a column or variable.
Flow Synchronization - 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.
Gender - Ascertains the correct salutation for various countries by using the first name.
Geocoder Transform - Appends latitude and longitude coordinates, Census track and block numbers, and county name and FIPS code to the ZIP+4^TM level.
If/Then/Else - The If/Then/Else provides a straightforward and intuitive way of implementing simple conditional logic.
If/Then/Multicast - The If/Then/Multicast provides a straightforward and intuitive way of implementing simple conditional logic.
Lookup - The Lookup Component allows lookup logic to be graphically defined. The existing SQL Server Integration Services component for this role is not actually bad, but there is a problem with caching dynamic data and it is effectively useless for looking up a value from a table or view thaty may actually be changed by your package. For example a typical use of a lookup component is to see if some peripheral data exists and create it if not.
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 - Merges duplicates within structured data pools (record linkage).
Merge/Purge/Deduplication
Microsoft CRM Lookup - The Microsoft CRM Lookup allows you to look up data from Microsoft CRM versions 3.0 and beyond.
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 - Deletes spaces at the start and end of a string and translates empty strings automatically into DBNULL.
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.
Organize Columns - The Organize Columns Component allows you to delete, rename, re-order and filter columns within a data-flow.
Phone - Validates and corrects phone numbers and customer data.
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.
RegExtractor - Allows you to define a regular expression with captured matches (backreferences) that you can apply to a column in your data flow. The captured matches are output as new columns in the data flow..
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.
Replacing Data Conversion - Converts column data types by replacing the column in the data flow (not adding a new one). Allows batch specification of conversions.
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.
SQL - The SQL Component provides a strongly types intuitive and graphical way of inserting, updating, deleting, upserting or merging data, executing a stored procedure, or executing tokenised SQL.
Table Difference - 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.
Unicode Conversion - The Unicode Conversion Component provides a strightforward way of mapping all string fields in a data-flow to unicode or ansi format.
Union All - The Union All Component merges data-flow outputs together, but in a dynamic way - that is the output fields are always updated automatically based on the inputs.
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.
Web Service Call - The Web Service Call Component allows you to easily consume web services.
Xmlify - Takes a series of columns and turns them into a single XML column.
Zip - The ZIP Component allows data to be compressed or decompressed.

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.
Dynamics CRM Destination - Store data to Dynamics CRM service.
Excel Destination Plus - Store data to Microsoft Excel workbook.
HTML Table Destination - creates an HTML-markup table of the Data Flow, typically for use with the Send HTML Mail Task.
Informix Destination - connects to Informix database and bulk loads data into Informix database tables.
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.
Microsoft CRM Destination - The Microsoft CRM Destination allows you to write data to Microsoft CRM versions 3.0 and beyond.
Microsoft CRM Update - The Microsoft CRM Destination allows you to update data in Microsoft CRM versions 3.0 and beyond.
Microsoft Sharepoint Update - Allows you to update list data in Microsoft SharePoint 2007 and beyond.
ODBC Destination - load data into ODBC-compatible database tables.
Oracle Bulk Load Connector
Oracle Bulk Loader - The Oracle Bulk Loader Component allows you to bulk insert data into Oracle more efficiently than using the standard ADO.Net or OLEDB provider.
Oracle - Achieve optimal performance when loading data into Oracle.
Oracle Destination - connects to Oracle database and bulk loads data into Oracle tables.
SalesForce - Write data to SalesForce.com.
SharePoint Destination - Store data to Microsoft SharePoint list.
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 - The SQL Component provides a strongly types intuitive and graphical way of inserting, updating, deleting, upserting or merging data, executing a stored procedure, or executing tokenised SQL.
Teradata - Achieve optimal performance when loading data into Teradata.
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
XML Destination - The Xml Destination Component allows you to create Xml data from column data, and then write this Xml data to a data-flow column or a variable. This component also then enables you to convert the Xml to EDI, Xml, HL/7, delimited, positional or binary formats.