When importing a single CSV file, the name of the table will be identical to the dataset name. The dataset name can have a maximum of 60 characters and is not allowed to contain the following special characters: . -, ", ', [, and ].
•Example: dbo.TaskDataSetname
If more than one CSV file is imported, multiple tables with a prefix and a suffix will be created. The prefix is always the dataset name of the task followed by a - (minus) and the suffix. The suffix is always the the filename of the CSV file.
•Example: dbo.TaskDataSetname-Filename
|
Note: It is possible for a user to change the prefix by changing the dataset name. It is not possible for a user to change the suffix since this is determined by the file name. |
