How to connect two data flow tasks in SSIS package programmatically?

Question

I am working on a console application which generates SSIS package. I have two data flow tasks which I need to connect in a certain order. How can the tasks be connected? I guess there must be something like a path between data flow task components such as

IDTSPath100 path = dataFlowTask.PathCollection.New();
path.AttachPathAndPropagateNotifications(component1.OutputCollection[0], component2.InputCollection[0])

Thanks in advance.

For programmatic generation of SSIS packages you may wish to look into BIML. — Nick.Mc, Dec 22 '15 at 23:36
Tasks are connected by `Precedence Constraints`. As to how to create them programmatically, I have no idea. — Tab Alleman, Dec 23 '15 at 15:26

score 1 · Accepted Answer · answered Dec 23 '15 at 18:16

1

You are looking for the package's PrecedenceConstraint collection and the Add method.

pkg.PrecedenceConstraints.Add(dftFrom, dftTo);

PrecedenceConstraints.Add Method

answered Dec 23 '15 at 18:16

billinkc

59,250
9
102
159

How to connect two data flow tasks in SSIS package programmatically?

1 Answers1