CreationName for SSIS 2008 and adding components programmatically

We start with a very simple snippet for adding a component:

// Add the Data Flow Task package.Executables.Add("STOCK:PipelineTask");// Get the task host wrapper, and the Data Flow task TaskHost taskHost = package.Executables[0] as TaskHost;MainPipe dataFlowTask = (MainPipe)taskHost.InnerObject;// Add OLE-DB source component - ** This is where we need the creation name **IDTSComponentMetaData90 componentSource = dataFlowTask.ComponentMetaDataCollection.New();componentSource.Name = "OLEDBSource";componentSource.ComponentClassID = "DTSAdapter.OLEDBSource.2"; 

So as you can see the creation name for a OLE-DB Source is DTSAdapter.OLEDBSource.2.

CreationName Reference 

ADO NET DestinationMicrosoft.SqlServer.Dts.Pipeline.ADONETDestination, Microsoft.SqlServer.ADONETDest, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91ADO NET SourceMicrosoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter, Microsoft.SqlServer.ADONETSrc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91AggregateDTSTransform.Aggregate.2AuditDTSTransform.Lineage.2Cache TransformDTSTransform.Cache.1Character MapDTSTransform.CharacterMap.2ChecksumKonesans.Dts.Pipeline.ChecksumTransform.ChecksumTransform, Konesans.Dts.Pipeline.ChecksumTransform, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992bConditional SplitDTSTransform.ConditionalSplit.2Copy ColumnDTSTransform.CopyMap.2Data ConversionDTSTransform.DataConvert.2Data Mining Model TrainingMSMDPP.PXPipelineProcessDM.2Data Mining QueryMSMDPP.PXPipelineDMQuery.2DataReader DestinationMicrosoft.SqlServer.Dts.Pipeline.DataReaderDestinationAdapter, Microsoft.SqlServer.DataReaderDest, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91Derived ColumnDTSTransform.DerivedColumn.2Dimension ProcessingMSMDPP.PXPipelineProcessDimension.2Excel DestinationDTSAdapter.ExcelDestination.2Excel SourceDTSAdapter.ExcelSource.2Export ColumnTxFileExtractor.Extractor.2Flat File DestinationDTSAdapter.FlatFileDestination.2Flat File SourceDTSAdapter.FlatFileSource.2Fuzzy GroupingDTSTransform.GroupDups.2Fuzzy LookupDTSTransform.BestMatch.2Import ColumnTxFileInserter.Inserter.2LookupDTSTransform.Lookup.2MergeDTSTransform.Merge.2Merge JoinDTSTransform.MergeJoin.2MulticastDTSTransform.Multicast.2OLE DB CommandDTSTransform.OLEDBCommand.2OLE DB DestinationDTSAdapter.OLEDBDestination.2OLE DB SourceDTSAdapter.OLEDBSource.2Partition ProcessingMSMDPP.PXPipelineProcessPartition.2Percentage SamplingDTSTransform.PctSampling.2Performance Counters SourceDataCollectorTransform.TxPerfCounters.1PivotDTSTransform.Pivot.2Raw File DestinationDTSAdapter.RawDestination.2Raw File SourceDTSAdapter.RawSource.2Recordset DestinationDTSAdapter.RecordsetDestination.2RegexCleanKonesans.Dts.Pipeline.RegexClean.RegexClean, Konesans.Dts.Pipeline.RegexClean, Version=2.0.0.0, Culture=neutral, PublicKeyToken=d1abe77e8a21353eRow CountDTSTransform.RowCount.2Row Count PlusKonesans.Dts.Pipeline.RowCountPlusTransform.RowCountPlusTransform, Konesans.Dts.Pipeline.RowCountPlusTransform, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992bRow NumberKonesans.Dts.Pipeline.RowNumberTransform.RowNumberTransform, Konesans.Dts.Pipeline.RowNumberTransform, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992bRow SamplingDTSTransform.RowSampling.2Script ComponentMicrosoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91Slowly Changing DimensionDTSTransform.SCD.2SortDTSTransform.Sort.2SQL Server Compact DestinationMicrosoft.SqlServer.Dts.Pipeline.SqlCEDestinationAdapter, Microsoft.SqlServer.SqlCEDest, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91SQL Server DestinationDTSAdapter.SQLServerDestination.2Term ExtractionDTSTransform.TermExtraction.2Term LookupDTSTransform.TermLookup.2Trash DestinationKonesans.Dts.Pipeline.TrashDestination.Trash, Konesans.Dts.Pipeline.TrashDestination, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b8351fe7752642ccTxTopQueriesDataCollectorTransform.TxTopQueries.1Union AllDTSTransform.UnionAll.2UnpivotDTSTransform.UnPivot.2XML SourceMicrosoft.SqlServer.Dts.Pipeline.XmlSourceAdapter, Microsoft.SqlServer.XmlSrc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

Here is a simple console program that can be used to enumerate the pipeline components installed on your machine, and dumps out a list of all components like that above. You will need to add a reference to the Microsoft.SQLServer.ManagedDTS assembly.

using System;using System.Diagnostics;using Microsoft.SqlServer.Dts.Runtime;public class Program{    static void Main(string[] args)    {        Application application = new Application();        PipelineComponentInfos componentInfos = application.PipelineComponentInfos;        foreach (PipelineComponentInfo componentInfo in componentInfos)        {            Debug.WriteLine(componentInfo.Name + "/t" + componentInfo.CreationName);        }        Console.Read();    }}