SQL Server Performance

Error - Datatype doesnot match

Discussion in 'SQL Server 2005 Integration Services' started by vaddi, May 31, 2007.

  1. vaddi New Member

    Hello,

    I have source table with columsn, Flight ID , Starting From , Destination. I bring them to a flat file ( i.e to a text file) and then loading into the dataware house dimension table. while I am mapping the columns , it gives me an error " data type does not match" when I try to map the Flight ID.

    The starting from and destination columns are mapping good.

    I have given the same datatype for Flight ID both in the source table and dimensional table i.e integer.

    What might be going wrong.

    Thanks
  2. dineshasanka Moderator

    hace you set the correct data type for the text file field

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page