MSDN Authoring Template

Other problems with DTS can occur when moving data between non-Unicode columns with a SQL Server 7.0 source and a SQL Server 2000 destination, when the collation of the SQL Server 2000 column is not one that is easily represented in SQL Server 7.0 (conversely, a SQL Server 2000 source and SQL Server 7.0 destination can also cause the same problem). ................
................