DT_STR is a null-
terminated ANSL/MBCS character string with maximum length of 8000 characters.
(if a column value contain additional null terminators, the string will be
truncated at the occurrence of the first null) it can used when data is in ANSL
code then SSIS package takes the data type as DT_STR. DT_ATR data type in SSIS
an be mapped to Char, VarChar data type in SQL Server
DT_WSTR is a a null terminated
Unicode character string with a maximum length of 4000 characters (if a column
value conations additional null terminators, the string will be truncated at
the occurrence of the first null.) it is
used when data is in Unicode then SSIS package takes the data type as DT_WSTR.
DT_WSTR data type in SSIS can be mapped to nChar ,nVarChar, Sql_Variant and
image data type in SQL Server .
Label: SSIS Interview Questions, Integration Services Interview Questions.
No comments:
Post a Comment