Source Database Artifact Naming Limits
Integration Services does not support source database table names and column names containing the characters listed in Table 22.
Note: | Table names may contain blank spaces. Column names may contain blank spaces and question marks. |
Note: | Table and column names may be greater than 30 characters in length. |
Table 22. Unsupported Characters in Table and Column Names
| | Character Description | | Character Description |
|---|
“ | quotation mark | ( ) | parenthesis |
& | ampersand | . | period |
, | comma | | | vertical pipe |
= | equal sign | ' | single quotation mark |
@ | at sign | \ | backslash |
# | pound sign | / | forward slash |
\t | Tab character | : | colon |
| | blank space | * | asterisk |
+ | plus sign | ? | question mark |
- | dash, minus sign, or hyphen | < | less than sign |
{ } | braces | > | more than sign |