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
