My First Dataflow (Job)
This example shows how to create a simple dataflow that reads data from a file, sorts it, then writes it to a file. Since this dataflow reads data from a file and writes its output to a file, it is a job: a dataflow that performs batch processing. (The other primary type of dataflow, a service, performs interactive processing via an API or web service call to the server.)
-
The first step will be to create some sample data to use as input to your
dataflow. Using a text editor, create a file that looks like this:
FirstName,LastName,Region,Amount Alan,Smith,East,18.23 Jeannie,Wagner,North,45.43 Joe,Simmons,East,10.87 Pam,Hiznay,Central,98.78
- Save the file in a convenient location.
- Select .
- Select .
-
You are now ready to begin creating your dataflow. The first step is to define
the input to the dataflow. To do this:
-
Next, you will add a stage that will sort the records by region. To do
this:
-
Finally, you will define the output file where the dataflow will write its
output. To do this:
- In Enterprise Designer, select .
- Give your dataflow a name and click OK.
- Your dataflow is now ready to run. Select .
- The Execution Details window appears and shows the status of the job. Click Refresh. Once the status shows Succeeded click Close.
Open the output file you specified in the Write to File stage. You will see that the records have been sorted by region as you specified in the Sorter stage.
FirstName,LastName,Region,Amount
Pam,Hiznay,Central,98.78
Alan,Smith,East,18.23
Joe,Simmons,East,10.87
Jeannie,Wagner,North,45.43
Congratulations! You have designed and run your first job dataflow.