Hi All, What is difference between DT_STR and DT_WSTR in ssis? Thanks CMK..

DT_STR is varchar means Non Unicode and DT_WST is Nvarchar means UnicodeGaurav Gupta http://sqlservermsbiblog.blogspot.com/

DT_STR A null-terminated ANSI/MBCS character string with a maximum length of 8000 characters. (If a column value contains additional null terminators, the string will be truncated at the occurrence of the first null.) DT_WSTR A null-terminated Unicode character string with a maximum length of 4000 characters. (If a column value contains additional null terminators, the string will be truncated at the occurrence of the first null.) reference: http://msdn.microsoft.com/en-us/library/ms141036.aspx http://www.rad.pasfu.com

Hi CMK, The difference is the same as between varchar and nvarchar: non-UNICODE vs. UNICODE. SSIS data types: http://msdn.microsoft.com/en-us/library/ms141036.aspx SQL Server data types: http://msdn.microsoft.com/en-us/library/ms187752.aspx Regards, Akim