ssis data type conversion of input column(454) is not supported

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  January 29, 2013 at 11:01 am

  #267822

  I am using SSIS pkg to export data from one server to another but i get the error "ssis data type conversion of input column(454) is not supported" for most of the columns in the table though source and destination data types are exactly same. any clue?

• Phil Parkin

  SSC Guru

  Points: 246992

  More actions

  January 29, 2013 at 12:02 pm

  #1582287

  Use the Advanced Editor on your data sources to have a look at all the datatypes involved & see whether that gives you any clues.

  It's difficult to provide more advice without more information from you.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel