Defaulting to DT_WSTR instead of DTSTR

• Narusegawa

  SSC Journeyman

  Points: 88

  More actions

  February 1, 2008 at 8:07 am

  #121916

  I have many files that have upwards of 66 columns in them. Column headings in the first row, however the suggested data types for most of these come out as DT_STR when I want to force DT_WSTR instead. Is this possible?

  I can't choose Unicode under the locale cos then it doesn't like the file itself. I'm importing from non-Unicode files into a Unicode database and lookups require the same datatypes are used 🙁

  Please help! 🙂

• Michael Ross-468051

  Say Hey Kid

  Points: 689

  More actions

  February 4, 2008 at 8:35 am

  #774763

  Consider using a Data Conversion Transformation to change the datatype of the input columns before comparing them.