CreationName for SSIS 2005 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.1"; 

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

CreationName Reference 

AggregateDTSTransform.Aggregate.1AuditDTSTransform.Lineage.1Character MapDTSTransform.CharacterMap.1ChecksumKonesans.Dts.Pipeline.ChecksumTransform.ChecksumTransform, Konesans.Dts.Pipeline.ChecksumTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992bConditional SplitDTSTransform.ConditionalSplit.1Copy ColumnDTSTransform.CopyMap.1Data ConversionDTSTransform.DataConvert.1Data Mining Model TrainingMSMDPP.PXPipelineProcessDM.1Data Mining QueryMSMDPP.PXPipelineDMQuery.1DataReader DestinationMicrosoft.SqlServer.Dts.Pipeline.DataReaderDestinationAdapter, Microsoft.SqlServer.DataReaderDest, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91DataReader SourceMicrosoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter, Microsoft.SqlServer.ADONETSrc, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91Derived ColumnDTSTransform.DerivedColumn.1DeUnicodeDeUnicode.DeUnicode, DeUnicode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=231268b283856821Dimension ProcessingMSMDPP.PXPipelineProcessDimension.1Excel DestinationDTSAdapter.ExcelDestination.1Excel SourceDTSAdapter.ExcelSource.1Export ColumnTxFileExtractor.Extractor.1Flat File DestinationDTSAdapter.FlatFileDestination.1Flat File SourceDTSAdapter.FlatFileSource.1Fuzzy GroupingDTSTransform.GroupDups.1Fuzzy LookupDTSTransform.BestMatch.1Import ColumnTxFileInserter.Inserter.1LookupDTSTransform.Lookup.1MergeDTSTransform.Merge.1Merge JoinDTSTransform.MergeJoin.1MulticastDTSTransform.Multicast.1OLE DB CommandDTSTransform.OLEDBCommand.1OLE DB DestinationDTSAdapter.OLEDBDestination.1OLE DB SourceDTSAdapter.OLEDBSource.1Partition ProcessingMSMDPP.PXPipelineProcessPartition.1Percentage SamplingDTSTransform.PctSampling.1PivotDTSTransform.Pivot.1Raw File DestinationDTSAdapter.RawDestination.1Raw File SourceDTSAdapter.RawSource.1Recordset DestinationDTSAdapter.RecordsetDestination.1RegexCleanKonesans.Dts.Pipeline.RegexClean.RegexClean, Konesans.Dts.Pipeline.RegexClean, Version=1.0.0.0, Culture=neutral, PublicKeyToken=d1abe77e8a21353eRow CountDTSTransform.RowCount.1Row Count PlusKonesans.Dts.Pipeline.RowCountPlusTransform.RowCountPlusTransform, Konesans.Dts.Pipeline.RowCountPlusTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992bRow NumberKonesans.Dts.Pipeline.RowNumberTransform.RowNumberTransform, Konesans.Dts.Pipeline.RowNumberTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992bRow SamplingDTSTransform.RowSampling.1Script ComponentMicrosoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91Slowly Changing DimensionDTSTransform.SCD.1SortDTSTransform.Sort.1SQL Server Compact Edition DestinationMicrosoft.SqlServer.Dts.Pipeline.SqlCEDestinationAdapter, Microsoft.SqlServer.SqlCEDest, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91SQL Server DestinationDTSAdapter.SQLServerDestination.1Term ExtractionDTSTransform.TermExtraction.1Term LookupDTSTransform.TermLookup.1Trash DestinationKonesans.Dts.Pipeline.TrashDestination.Trash, Konesans.Dts.Pipeline.TrashDestination, Version=1.0.1.0, Culture=neutral, PublicKeyToken=b8351fe7752642ccUnion AllDTSTransform.UnionAll.1UnpivotDTSTransform.UnPivot.1XML SourceMicrosoft.SqlServer.Dts.Pipeline.XmlSourceAdapter, Microsoft.SqlServer.XmlSrc, Version=9.0.242.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();    }}