Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DTS Error - Quoted Identifier

Author  Topic 

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2001-07-30 : 17:45:18
I have SysAdmin rights (although I use my own personal login. So far, I haven't found anything helpful in BOL...

In doing a SQL 7 to SQL 7 transfer of a database, using the Import (DTS) wizard, it fails in processing with the error message
[SQL-DMO]Failed to set Quoted Identifier setting. 


So, I went back to the DTS settings and turned OFF the option to use Quoted Identifiers, and now I get the error message
 [Mircrosoft][ODBC SQL Server Driver][SQL Server]Line 8: Incorrect Syntax near 'TH'.


Where should I turn my research to now?

Thanks In Avance!

MC

------------------------------------------------------------------
Contractor$ never die, they just leave for higher-paying project$.

Edited by - AjarnMark on 07/30/2001 17:50:35
   

- Advertisement -