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 - 2001-03-26 : 10:55:20
|
Jo writes "SQL Server 7.0 Service Pack 3.
We have a DTS package which needs to update an Oracle table based on data in a SQL Server table using a data driven query
The source tab, selects an ID column from the SQL Server table and the destination tab, points to an Oracle table.
We have tried the following.
The transformation tab is set to activex.
The queries tab has the following settings
Query Type : update
Query
Update oracletable
set status = 'E'
where ID = (?)
Destination to parameter mapping set to
Destination Paramaters
ID Parameter 1
This results in a data driven error with no explanation.
Can anyone help ?" |
|
|
|
|
|
DTS - Updating an Oracle table