Excel Destination
Data types . The Excel driver recognizes only a limited set of data types. For example, all numeric columns are interpreted as doubles (DT_R8), and all string columns (other than memo columns) are interpreted as 255-character Unicode strings (DT_WSTR). Integration Services maps the Excel data types as follows: Numeric double-precision float (DT_R8) Currency currency (DT_CY) Boolean Boolean (DT_BOOL) Date/time datetime (DT_DATE) String Unicode string, length 255 (DT_WSTR) Memo Unicode text stream (DT_NTEXT) MSDN