Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

API Sample - Create a package with a data flow task

SSIS-Team's avatar
SSIS-Team
Copper Contributor
Mar 25, 2019
First published on MSDN on Dec 30, 2008

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;
}
http://11011.net/software/vspaste
Updated Mar 25, 2019
Version 2.0

1 Comment

  • AleBarreto's avatar
    AleBarreto
    Copper Contributor

    Hi, I have a SAP API, can I use SSIS to migrate data? Are there any connector?