DT_STR Vs DT_WSTR?

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.