SSIS设计师鼓励重用…

SQL Server集成服务提供了一些功能的模块化允许你组织你的包,这样他们的工作效率,可以轻松维护。例如,SSIS设计师有四个不同的标签:控制流、数据流、事件处理程序和Package Explorer。这允许您关注一次包的一部分,并鼓励重用的组件。在DTS 2000我们有一个工作流处理包括数据流和事件处理的标志性图很快变得非常混乱。我叫控制流选项卡的“场景”快乐。这表明我们的包应该做一个美好的一天。换句话说,执行任务的高级视图包在正常情况下和顺序。所有的错误处理和事件处理可以隐藏在事件处理程序选项卡下。暗示,选项卡拥有“不愉快的场景”虽然可以用于审计除了标准错误处理。无论哪种方式,它不混乱我们的视图的控制流,当我们正在计划的一部分。 The Data Flow tab provides a diagram for each Data Flow task in the package, the most popular task in SSIS. Again, this allows the Control Flow to be simplified, as each Data Flow task is represented by a single task object. Just double-click the Data Flow task (or right-click and Edit) and the SSIS Designer will switch to the Data Flow tab for that task to show all the detail hidden within that task. Again, this modular approach encourages re-use. The Event Handler tab can use the same types of tasks and containers as are used on the Control Flow, but each event has its own flow diagram, again hidden away until you need to see it. You could write data to an audit table or send an email based on a particular event including the commonly specified “OnError” event. The Package Explorer tab gives an alternate view of the package in a tree structure format similar to Windows Explorer. For large packages, this allows us to navigate quickly to a particular task. Double-clicking a task (under Executables) will take us to that object in the package. When we are debugging, SSIS Designer does provide a fifth tab for Progress. This will show us the major milestones of the package execution as they happen and can be very useful when errors occur during testing. Call me an optimist, but I like working on the Control Flow without having to worry about the error processing until later in the project. That keeps me happy. Cheers Brian