Has anyone see this error before. I am transferring between 2 2000 databases on the same server. I have turned off the "Use collate" option on the DTS. And both db's have the same collation name properties.

error reads as follows.

[Microsoft][ODBC SQL Server Driver][SQL SERVER]Line 5: Incorrect syntax near 'COLLATE'.

PLEASE HELP