File Element (DTA)
Applies to: 
SQL Server
Specifies the workload file. A workload is a set of Transact-SQL statements that execute against a database or databases that you want to tune. Workload files can be Transact-SQL scripts (.sql) or trace files (.trc). For more information, see Start and Use the Database Engine Tuning Advisor.
Syntax
<DTAInput>
<Server>...</Server>
<Workload>
<File>...</File>
</Workload>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data type and length | Use the string data type to specify the directory path to your workload file. For example:<File>C:\Tuning\tun.sql</File>Note that length limit is enforced by the server. |
| Default value | None. |
| Occurrence | Required once if no other type of workload is specified. You must specify an EventString, a File, or a Database child element for the Workload parent, but only one type can be used. For example, if you specify a workload with the File element, then you cannot also specify a workload with the Database element in the same XML input file. |
Element Relationships
| Relationship | Elements |
|---|---|
| Parent element | Workload Element (DTA) |
| Child elements | None. |
Example
For a usage example of this element, see Simple XML Input File Sample (DTA).