Connecting SQL task to data flow task programatically (c#)

Question

How can I connect a SQL task to a data flow task programatically?

SQL Task:

Executable exec = package.Executables.Add("STOCK:SQLTask");
TaskHost thMainPipe = (TaskHost)exec;

...

Data flow:

MainPipe mp = ((TaskHost)stagingPackage.Executables.Add("DTS.Pipeline")).InnerObject as MainPipe;

...

Tried using PrecedenceConstraints.Add, get COM error.

PrecedenceConstraints.Add(derivedTask,(Executable) mp);

Unable to cast COM object of type 'System.__ComObject' to class type 'Microsoft.SqlServer.Dts.Runtime.Executable'.

See my post as an answer, Up Vote / Accept my answer if it's solved your problem. — S.M
– S.M, Commented Jul 4, 2013 at 15:23

S.M · Accepted Answer · 2013-07-04 15:33:28Z

1

Use STOCK:PipelineTask in place of DTS.Pipeline. Executables.Add() Method expect CLSID, PROGID, STOCK moniker, or CreationName property of the TaskInfo object. STOCK moniker is mostly used. DTS.Pipeline might not have recognized as any of them. If not using Stock Moniker, specify CLSID or PROGID equivalent to STOCK:PipelineTask.

edited Jul 4, 2013 at 15:33

answered Jul 4, 2013 at 15:05

S.M

7763 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connecting SQL task to data flow task programatically (c#)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related