I have an SSIS package that reads from a FoxPro 6 database and writes to a SS2005 database. It does not do any manipulations, just a straight data move.
One of my columns is causing me an unusual problem... it is a char(10) in FoxPro and a varchar(10) in SQL. However, I get this error in SSIS when I run the package:
Error: 0xC020837F at Data Flow Task, DataReader Source : The data type of "output column "soc_sec4" (22964)" does not match the data type "System.String" of the source column "soc_sec4".