Data Job Node
Use the Data Job node to add a data job in the flow for a process job. The data job would contain a set of data-processing operations that are appropriate for the current process job. For more information about the tabs at upper left of this dialog, click the following links:
Overview
The Data Flow tab (upper left) is displayed by default. The two main components of this tab are the Nodes tree on the left and the Data Flow Editor on the right (open area with the toolbar above it). The Nodes tree contains all of the nodes that can be used in the context of a data job. For an overview of all data job nodes, see Data Job Nodes. The Data Flow Editor is used to arrange nodes in a flow from source to target.
If enabled, the Details pane appears above the Job Status bar in the dialog. To enable the Details pane, select View > Show Details Pane from the main menu. The Details pane enables you to quickly view or update the attributes of a selected node in the context of the flow, without having to open the properties window for the node. The Details pane for a data job includes the following tabs:
- Basic Settings - Displays the Name, Description, and Notes for the selected node.
- Advanced Properties - Displays the advanced properties for the selected node. See Advanced Properties for more information.
- Node Connections - Displays the connections between the nodes included in the flow. You can add a connection, delete a selected connection, delete all of the connections, and change the order of the connections.
- Preview - Displays the contents of the selected node. You should consider previewing the nodes in a data job to ensure that will get the results that you expect when you run the job. You can preview a node by selecting it and clicking the Preview tab. Note that the data viewer in preview displays might display fewer rows than you need to see. If you need to see more rows, open the Tools menu and click Data Management Studio Options. Then, click DataViewer and enter an appropriate value in the Number of rows to show in the preview pane field. Finally, you can quickly review the output of a table in a data job by previewing it after the run is successfully completed.
- Log - Displays a log for the selected node. If no nodes are selected, displays a log for the job that contains the node. For more information, see Log Tab.
The Job Status bar at the bottom of the dialog displays the run-time status of the current job. It displays messages such as "Running" or "Completed Successfully."