[SQL Server] Line 1: Incorrect syntax near 's'

[Guest_imported]

I get this message when I run the DTS Service from the EM.

 

[pmanivas]

What is ur query?

 

[Guest_imported]

There is no query. I am running the DTS to copy a database to another server. I keep getting this error, even though I have gone through all of the views and sp's and I cannot find any error in them.

 

[pmanivas]

I understand u r using DTS
But in DTS you would have several steps to copy the tables
There might be transformations used which might be queries or scipts
Thats why I asked u.
Both Source & destinations are sql server DBs or different?

 

[Guest_imported]

Both of the servers are SQL 7.0 SP3. I am not using queries, I am letting the wizard do it all.

 

[pmanivas]

Whether the objects that are being transfered are already exist in the destination server or newly created?

 

[Guest_imported]

I have done it both ways and it still won't work.

 

[pmanivas]

Check the properties of both the servers & databases
Make sure both of them are same.