Connect to a Flat File (SSAS)
This page of the Table Import Wizard enables you to connect to a flat file (.txt), tab-separated file (.tab), or a comma-separated file (.csv). To access the wizard from the SQL Server Data Tools, on the Model menu, click Import from Data Source.
To connect to a flat file, you must have the ACE provider installed on your computer. For more information, see Data Sources Supported (SSAS Tabular).
Note
The credentials of the current user are used when selecting a file in this page. However, import will not succeed if the user specified in the Impersonation Information page does not have sufficient privileges to read from the selected file.
UI element list
Friendly connection name
Type a unique name for this data source connection. This is a required field.
File Path
Specify a full path for the file.
Browse
Navigate to a location where a file is available.
Column Separator
Select from a list of available column separators. Choose a separator that is not likely to occur in the text.
| Value | Description |
|---|---|
| Tab (t) | Columns are separated by a tab (t). |
| Comma (,) | Columns are separated by a comma (,). |
| Semicolon (;) | Columns are separated by a semicolon (;). |
| Space ( ) | Columns are separated by a space ( ). |
| Colon (:) | Columns are separated by a colon (:). |
| Vertical Bar (|) | Columns are separated by a vertical bar (|). |
Advanced
Specify the encoding and locale options for the flat file.
Use first row as column headers
Specify whether to use the first data row as the column headers of the destination table.
Data preview
Preview the data in the selected file, and use the following options to modify the data import.
Note
Only the first 50 rows in the file are displayed in this preview.
| Option | Description |
|---|---|
| Checkbox in the column header | Select the checkbox to include the column in the data import. Clear the checkbox to remove the column from the data import. |
| Down-arrow button in the column header | Sort and filter data in the column. |
Clear Row Filters
Remove all filters that were applied to the data in the columns.