 | |
Problem updating AS400 file with DTS
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Problem updating AS400 file with DTS -
08-12-2003
, 02:03 AM
#2
| |||
| |||
|
|
When i try to update a AS400 file (using Client access 5.2 drivers) with DTS on SQL 2000 i get the following message: "Query cannot update because it contains no searchable columns to use as a key". The DTS transformation fails altough when i test the transformation, the test completes successfully. This problem appeared after we migrated from SQL 7 to SQL 2000. I can create a file on the AS400 using DTS, no problem! Any advise would be helpful. Thanks, Tilo |
#3
| |||
| |||
|
|
-----Original Message----- Are there any Key cols on the AS4000 file ? -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Tilo" <tvonbrandis (AT) safair (DOT) co.za> wrote in message news:0be501c3609f$c53901e0$a101280a (AT) phx (DOT) gbl... When i try to update a AS400 file (using Client access 5.2 drivers) with DTS on SQL 2000 i get the following message: "Query cannot update because it contains no searchable columns to use as a key". The DTS transformation fails altough when i test the transformation, the test completes successfully. This problem appeared after we migrated from SQL 7 to SQL 2000. I can create a file on the AS400 using DTS, no problem! Any advise would be helpful. Thanks, Tilo . |
#4
| |||
| |||
|
|
I tried a file with and without keys Regards, Tilo -----Original Message----- Are there any Key cols on the AS4000 file ? -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Tilo" <tvonbrandis (AT) safair (DOT) co.za> wrote in message news:0be501c3609f$c53901e0$a101280a (AT) phx (DOT) gbl... When i try to update a AS400 file (using Client access 5.2 drivers) with DTS on SQL 2000 i get the following message: "Query cannot update because it contains no searchable columns to use as a key". The DTS transformation fails altough when i test the transformation, the test completes successfully. This problem appeared after we migrated from SQL 7 to SQL 2000. I can create a file on the AS400 using DTS, no problem! Any advise would be helpful. Thanks, Tilo . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.