If I remove the varchar column from the dts transformation it runs fine, since the only column left is an integer. How do I fix the varchar problem? The source table is SQL Server 7 and the destination is MySql 5.
