Dialog for Data Jobs
You can use this dialog to add or update a data job. For more information about the tabs at upper left of this dialog, click the following links:
- Data Job Tab or Data Flow Tab - Enables you to build and maintain data flows.
- Settings Tab - Enables you to set the properties for data jobs.
- Variables Tab - Displays the variables associated with the data job.
- Log Tab - Displays the log for the data job.
Overview
The Data Job 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 tool bar above it). The Nodes tree contains all of the nodes that can be used in the context of a data job. The Data Flow Editor is used to arrange nodes in a flow from source to target. For an overview of all data job nodes, see Data Job Nodes. To see the online help for each node, select it in the Nodes tree, and then click the Help link in the pane at the bottom of the Nodes tree.
If enabled, the Details pane appears above the Job Status line of 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 line at the bottom of the dialog displays the run-time status of the current job. It displays messages such as "Running" or "Completed Successfully."