The DTS MS SQL Server Connector fully supports all tables and views in MS SQL Server and does not differentiate between the two.
DTS Naming
DTS Name |
<table_or_view_name> |
DTS Key |
<schema_name>.<table_or_view_name> |
Metadata
The connector is also capable of extracting metadata regarding the table/view columns:
▪DATA_TYPE
▪CHARACTER_OCTET_LENGTH
▪CHARACTER_MAXIMUM_LENGTH
▪NUMERIC_PRECISION
▪DATETIME_PRECISION
▪NUMERIC_SCALE
▪IS_NULLABLE
▪ORDINAL_POSITION
▪CONSTRAINT -> PRIMARY_KEY
Standard functionality only makes use of DATA_TYPE, ORDINAL_POSITION and PRIMARY_KEY, but the other items are available for extension in DTS descriptor objects.
Structured types (table types) are not supported as column data types by MS SQL Server, only native and user types are. Please see Types for information of how the connector handles these.