Data type conversions RRS feed

  • Question

  • I am just starting to lean and use SSIS to get data from an AS400 DB2 database.  (I also posted this question to the SSIS newsgroup).

    It all works for columns that are just a data type of Character, however I am having a problem with the Numeric data type.  I keep getting an error "column cannot be inserted because the conversion between types DT_NUMERIC and DT_R8 is not supported."

    In SQL, what do I need to declare the column datatype as?  I have tried several.

    Thanks for the information.

    Monday, January 2, 2006 8:22 PM