CreationName for SSIS 2005 and adding components programmatically-CSDN博客

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

Aggregate	DTSTransform.Aggregate.1
Audit	DTSTransform.Lineage.1
Character Map	DTSTransform.CharacterMap.1
Checksum	Konesans.Dts.Pipeline.ChecksumTransform.ChecksumTransform, Konesans.Dts.Pipeline.ChecksumTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992b
Conditional Split	DTSTransform.ConditionalSplit.1
Copy Column	DTSTransform.CopyMap.1
Data Conversion	DTSTransform.DataConvert.1
Data Mining Model Training	MSMDPP.PXPipelineProcessDM.1
Data Mining Query	MSMDPP.PXPipelineDMQuery.1
DataReader Destination	Microsoft.SqlServer.Dts.Pipeline.DataReaderDestinationAdapter, Microsoft.SqlServer.DataReaderDest, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
DataReader Source	Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter, Microsoft.SqlServer.ADONETSrc, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
Derived Column	DTSTransform.DerivedColumn.1
DeUnicode	DeUnicode.DeUnicode, DeUnicode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=231268b283856821
Dimension Processing	MSMDPP.PXPipelineProcessDimension.1
Excel Destination	DTSAdapter.ExcelDestination.1
Excel Source	DTSAdapter.ExcelSource.1
Export Column	TxFileExtractor.Extractor.1
Flat File Destination	DTSAdapter.FlatFileDestination.1
Flat File Source	DTSAdapter.FlatFileSource.1
Fuzzy Grouping	DTSTransform.GroupDups.1
Fuzzy Lookup	DTSTransform.BestMatch.1
Import Column	TxFileInserter.Inserter.1
Lookup	DTSTransform.Lookup.1
Merge	DTSTransform.Merge.1
Merge Join	DTSTransform.MergeJoin.1
Multicast	DTSTransform.Multicast.1
OLE DB Command	DTSTransform.OLEDBCommand.1
OLE DB Destination	DTSAdapter.OLEDBDestination.1
OLE DB Source	DTSAdapter.OLEDBSource.1
Partition Processing	MSMDPP.PXPipelineProcessPartition.1
Percentage Sampling	DTSTransform.PctSampling.1
Pivot	DTSTransform.Pivot.1
Raw File Destination	DTSAdapter.RawDestination.1
Raw File Source	DTSAdapter.RawSource.1
Recordset Destination	DTSAdapter.RecordsetDestination.1
RegexClean	Konesans.Dts.Pipeline.RegexClean.RegexClean, Konesans.Dts.Pipeline.RegexClean, Version=1.0.0.0, Culture=neutral, PublicKeyToken=d1abe77e8a21353e
Row Count	DTSTransform.RowCount.1
Row Count Plus	Konesans.Dts.Pipeline.RowCountPlusTransform.RowCountPlusTransform, Konesans.Dts.Pipeline.RowCountPlusTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992b
Row Number	Konesans.Dts.Pipeline.RowNumberTransform.RowNumberTransform, Konesans.Dts.Pipeline.RowNumberTransform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b2ab4a111192992b
Row Sampling	DTSTransform.RowSampling.1
Script Component	Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost, Microsoft.SqlServer.TxScript, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
Slowly Changing Dimension	DTSTransform.SCD.1
Sort	DTSTransform.Sort.1
SQL Server Compact Edition Destination	Microsoft.SqlServer.Dts.Pipeline.SqlCEDestinationAdapter, Microsoft.SqlServer.SqlCEDest, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
SQL Server Destination	DTSAdapter.SQLServerDestination.1
Term Extraction	DTSTransform.TermExtraction.1
Term Lookup	DTSTransform.TermLookup.1
Trash Destination	Konesans.Dts.Pipeline.TrashDestination.Trash, Konesans.Dts.Pipeline.TrashDestination, Version=1.0.1.0, Culture=neutral, PublicKeyToken=b8351fe7752642cc
Union All	DTSTransform.UnionAll.1
Unpivot	DTSTransform.UnPivot.1
XML Source	Microsoft.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();
    }
}