Wednesday, September 08, 2004 - Posts

DTS Runtime


When you programmatically create a package or a custom object for DTS, you have to think in two different modes: DesignTime and RunTime. DesignTime is for when you’re building the package, for when you’re setting up all the flows and connections. RunTime is for when the package executes. The goal is to make the RunTime flows as fast as possible by getting everything else set up in advance. This all makes sense. There is a tad bit of confusion about the fact that the term RunTime is also used sometimes to refer to the control flow part of a package—to the sequenced execution of tasks, as opposed to the data flow, which is also called the PipeLine. As long as you keep the two uses of RunTime separate, you can clearly call DesignTime methods of RunTime components or properly implement RunTime methods for a custom PipeLine componenent

Reed