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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-23 : 08:08:44
|
| hong writes "The DST copy 1 table between two SQL 2000 servers. Both source and destination are tables. It runs OK during day one. Then it failed. The error message reads: Line 1: incorrect syntax near ¡°1077277¡±. In the transformation task properties, source tab, 1077277 was showed as query string in the SQL query text box. The original choice in the table/view dropdown list grayed out. I have rebuilt the whole thing, but the problem is still there.That number is one of the values of my source table¡¯s first field. It is not the first one, neither the last. How did that get into the package? It is so wired, I don¡¯t even know where to look for help." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-23 : 12:48:48
|
| Did you create the table on the destination server or did you let DTS do it for you? If you let DTS do it, I would script out the table on the source server, then create it on the destination server using the script. Then run DTS.You should also consider using bcp instead of DTS. You could also use linked servers for this and just use INSERT INTO.Tara |
 |
|
|
|
|
|
DTS Transformation task error