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-10-16 : 08:20:25
|
| hong writes "I have build half dozen DTSs. They are running fine on my machine, but failed to finished on the server. So far this is a story too familiar to us, but this time, the following error message baffled our dba and me.¡°Query cannot be updated because it contains no searchable columns to use as a key¡±.I even found an article from the MSDN KB.http://support.microsoft.com/default.aspx?scid=kb;en-us;326166It has something to do with using query to update a cursor while the cursor doesn¡¯t contain any key column in it. And it is a by design behavior of the OLE DB Provider for ODBC driver. On our case, I did not manipulate cursor/query whatsoever. It is a strict copy table from SQL2k to DB2 through Client Access ODBC Driver. All tables have primary keys. Both connections (DSNs) to the source and the destination seem good. At the server machine¡¯s EM, I can preview the data from the source, as well as seeing the table field name from the destination. And the DTS is executed manually instead of as a scheduled job. The error showed up at the lat step of the package.Anybody have any idea? Thanks!" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2003-10-16 : 13:48:53
|
| What type of cursor are you using? Keyset, dynamic, static?Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Tough DTS execution error