I am using Microsoft SQL Server 2000 and need some slight help in importing and transforming some data.
Below is the auto-generated script from Microsoft:
DTSDestination("Code") = DTSSource("Col001")
DTSDestination("User_Cancel1") = DTSSource("Col002")
Main = DTSTransformStat_OK
The first DTSDestination is the primary key of the database, and already has data in it. I want the script to find all matches between "Code" and "Col001", and then update "User_Cancel1" with "Col002".
If I run the script as is, I am given an error that it cannot insert duplicate data into the table.
I just want the script to FIND the first variable, and then update the second variable in the row.
I assume it's easy but I don't know VB well.
Thanks in advance.