When your data flow or control flow design is complete,
you can run the flow directly from the Design Studio. A run profile
is a predefined set of requirements for running a particular flow,
including database connection properties, values to use for variables,
and diagnostic information.
A default run profile is the collection of resources
and variables that are required by the currently selected data flow,
control flow, or execution plan graph (EPG). This profile contains
the settings as they were when you last edited them; in the case of
data flows and EPGs, these settings include the last-selected SQL
execution database. A saved run profile is a profile that you
explicitly save after making adjustments to the default settings.
Run profiles belong only to the specific flow or EPG that you are
currently running or debugging.
The same run profile features
are available in the data flow, control flow, and EPG editors. The
resource and variable information that you need to provide is the
same as the information that you provide when you create and edit application
profiles during deployment preparation. The run profile for an
EPG is the same as the profile that is defined for its source flow.
For example, if you are executing data flow DF1 and
you save a run profile called RunProfDF1, this
profile is also available when you debug or execute the EPG for that
data flow.
To create a run profile:
- Open a data flow, control flow, or EPG and make sure its
tab is selected above the canvas. The appropriate
menu becomes available (Data Flow, Control
Flow, or EPG).
- Select Execute. The
Flow Execution window opens.
- Work through the four tabs (General, Diagnostics, Resources,
and Variables) and define the settings that
you would like to use when you run this data flow or other data flows
in the project. Critical properties of a run profile include
the name of the SQL execution database, definitions of data sources,
and runtime values for variables. The Diagnostics page contains default
locations and settings for logging and tracing on the Design Studio
client.
- Click Save and give the profile
a name (or accept the default name). The default name consists of
the string Default_Run_Profile_, then the data
warehousing project name, then file1. For example: Default_Run_Profile_sqlwSample_file1
- After saving a profile, you can close the Flow Execution
window or execute the current flow or EPG. You can execute with the
profile that you just defined, another saved run profile, or the default
run profile. The new profile that you created is
stored in the Run Profiles folder inside your data warehousing project.