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 - 2000-08-19 : 18:03:17
|
Upen writes "I am trying to use the data driven query task in the DTS designer, on SQL 2000 beta 2 build 100. What I am trying to accomplish is to check if the destination has a NULL value for a given record of the source, if it does then execute the DTSTransformStat_InsertQuery, else execute the
DTSTransformStat_UpdateQuery.
This is what I have done so far:
IF DTSDestination("PLANT_H1_ID") = DTSSource("PLANT_H1_ID") Then
Main = DTSTransformstat_UpdateQuery
ELSE
Main = DTSTransformstat_InsertQuery
END IF
The insert part works but the Update part update the destination table with the same values.
PLEASE HELP
Thank you in advance.
" |
|
|
|
|
|
DTS