Error – Datatype doesnot match | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error – Datatype doesnot match

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

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