API Sample - Create a package with a data flow task

API Sample - Create a package with a data flow task

  • Comments 6

This code creates a package with a single data flow task. It will be used as a base for the more complicated code samples.

static void Main(string[] args)
{
    Package package = new Package();

    // Add Data Flow Task
    Executable dataFlowTask = package.Executables.Add("STOCK:PipelineTask");

    // Set the name (otherwise it will be a random GUID value)
    TaskHost taskHost = dataFlowTask as TaskHost;
    taskHost.Name = "Data Flow Task";

    // We need a reference to the InnerObject to add items to the data flow
    MainPipe pipeline = taskHost.InnerObject as MainPipe;
}
Leave a Comment
  • Please add 3 and 5 and type the answer here:
  • Post
  • This is an index post for the series of posts with examples on how to create packages programmatically.

  • 1. 构建一个包含数据流任务(Data Flow Task)的包 下面的代码可以生成一个包含数据流任务的包,这个包不执行任何实际的工作,但是可以作为构建一个更复杂的包的基础: static void Main(

  • Hello Matt,

    The samples you give are very good, but I really wish we had either a list of prerequisites, or a link to actually setting up the project to get to the point where this is helpful to us. For example, if I create a project, and just replace the main with your code sample, I get errors when I try to compile telling me that the Type or Namespace 'Package' cannot be found.

    Could you help us get to the point where your samples work? Thank you for your work!

  • Hi Stevenhowards !

       1) You should add reference: Microsoft.SQLServer.DtsRuntimeWrap

        2) Then add using Microsoft.SqlServer.Dts.Runtime; in top of your code

    Goodluck !

  • hi

    how prepare a ssis package to load the data from a flatfile

    just show me the code

  • Hi can anyone tell me the hierarchy how we should create the package when we does programmatically and why to do in that order? Like Package --> ControlFlow --> DataFlow and so on.

Page 1 of 1 (6 items)