I've got a table I'm tring to write a data driven query against to either add
a new record or update an existing one based on the value in the first field
of the text file I'm importing. "N" means add a new one, "U" means update an
existing record. The task appears to run just fine, and all records with an
"N" get added to the database. However, records with a "U" don't get
updated. I'm getting no errors, but when I query the data the update clearly
didn't occur because the old values are still there. Following is my
transformation script along with the Update query. I've verified that the
Destination to Parameter Mapping is correct. Sorry if it's a bit lengthy...

'************************************************* *********************
' Visual Basic Transformation Script
'************************************************* ***********************

' Copy each source column to the destination column
Function Main()
SELECT Case Trim(DTSSource("Col001"))
CASE "N"
DTSDestination("WorkOrderNumber") = DTSSource("Col002")
DTSDestination("WorkOrderType") = DTSSource("Col003")
DTSDestination("DateReleased") = DTSSource("Col004")
DTSDestination("DateFirstIssued") = DTSSource("Col005")
DTSDestination("DateAccountingClosed") = DTSSource("Col006")
DTSDestination("PartNumber") = DTSSource("Col007")
DTSDestination("QuantityToMake") = DTSSource("Col008")
DTSDestination("QuantityComplete") = DTSSource("Col009")
DTSDestination("StandardLaborHours") = DTSSource("Col010")
DTSDestination("ActualLaborHours") = DTSSource("Col011")
DTSDestination("StandardMachineHours") = DTSSource("Col012")
DTSDestination("ActualMachineHours") = DTSSource("Col013")
DTSDestination("MachineHPK") = DTSSource("Col014")
DTSDestination("LaborHPK") = DTSSource("Col015")
DTSDestination("WorkCenter") = DTSSource("Col016")
DTSDestination("FirstRoutingSequence") = DTSSource("Col017")
DTSDestination("StandardCost") = DTSSource("Col018")
DTSDestination("StandardLaborCost") = DTSSource("Col019")
DTSDestination("StandardMaterialCost") = DTSSource("Col020")
DTSDestination("StandardBurdenCost") = DTSSource("Col021")
DTSDestination("ActualCost") = DTSSource("Col022")
DTSDestination("ActualLaborCost") = DTSSource("Col023")
DTSDestination("ActualMaterialCost") = DTSSource("Col024")
DTSDestination("ActualBurdenCost") = DTSSource("Col025")
DTSDestination("ActualMaterialBurdenCost") = DTSSource("Col026")
DTSDestination("ActualVariableBurdenCost") = DTSSource("Col027")
DTSDestination("ActualFreightCost") = DTSSource("Col028")
DTSDestination("ActualOutplantCost") = DTSSource("Col029")
DTSDestination("CurrentDateScheduledComplete") = DTSSource("Col030")
DTSDestination("OriginalDateScheduledComplete") = DTSSource("Col031")
DTSDestination("SecondRoutingSequence") = DTSSource("Col032")
DTSDestination("ThirdRoutingSequence") = DTSSource("Col033")
DTSDestination("SecondWorkCenter") = DTSSource("Col034")
DTSDestination("ThirdWorkCenter") = DTSSource("Col035")
Main = DTSTransformStat_InsertQuery
CASE "U"
DTSDestination("WorkOrderNumber") = DTSSource("Col002")
DTSDestination("WorkOrderType") = DTSSource("Col003")
DTSDestination("DateReleased") = DTSSource("Col004")
DTSDestination("DateFirstIssued") = DTSSource("Col005")
DTSDestination("DateAccountingClosed") = DTSSource("Col006")
DTSDestination("PartNumber") = DTSSource("Col007")
DTSDestination("QuantityToMake") = DTSSource("Col008")
DTSDestination("QuantityComplete") = DTSSource("Col009")
DTSDestination("StandardLaborHours") = DTSSource("Col010")
DTSDestination("ActualLaborHours") = DTSSource("Col011")
DTSDestination("StandardMachineHours") = DTSSource("Col012")
DTSDestination("ActualMachineHours") = DTSSource("Col013")
DTSDestination("MachineHPK") = DTSSource("Col014")
DTSDestination("LaborHPK") = DTSSource("Col015")
DTSDestination("WorkCenter") = DTSSource("Col016")
DTSDestination("FirstRoutingSequence") = DTSSource("Col017")
DTSDestination("StandardCost") = DTSSource("Col018")
DTSDestination("StandardLaborCost") = DTSSource("Col019")
DTSDestination("StandardMaterialCost") = DTSSource("Col020")
DTSDestination("StandardBurdenCost") = DTSSource("Col021")
DTSDestination("ActualCost") = DTSSource("Col022")
DTSDestination("ActualLaborCost") = DTSSource("Col023")
DTSDestination("ActualMaterialCost") = DTSSource("Col024")
DTSDestination("ActualBurdenCost") = DTSSource("Col025")
DTSDestination("ActualMaterialBurdenCost") = DTSSource("Col026")
DTSDestination("ActualVariableBurdenCost") = DTSSource("Col027")
DTSDestination("ActualFreightCost") = DTSSource("Col028")
DTSDestination("ActualOutplantCost") = DTSSource("Col029")
DTSDestination("CurrentDateScheduledComplete") = DTSSource("Col030")
DTSDestination("OriginalDateScheduledComplete") = DTSSource("Col031")
DTSDestination("SecondRoutingSequence") = DTSSource("Col032")
DTSDestination("ThirdRoutingSequence") = DTSSource("Col033")
DTSDestination("SecondWorkCenter") = DTSSource("Col034")
DTSDestination("ThirdWorkCenter") = DTSSource("Col035")
Main = DTSTransformStat_UpdateQuery
CASE ELSE
Main = DTSTransformStat_UserQuery
END SELECT
End Function

//////////////////// END OF TRANSFORMATION ////////////////////////////

UPDATE WorkOrders
SET WorkOrderType = ?, DateReleased = ?,
DateFirstIssued = ?, DateAccountingClosed = ?,
PartNumber = ?, QuantityToMake = ?,
QuantityComplete = ?, StandardLaborHours = ?,
ActualLaborHours = ?, StandardMachineHours = ?,
ActualMachineHours = ?, MachineHPK = ?,
LaborHPK = ?, WorkCenter = ?,
FirstRoutingSequence = ?, StandardCost = ?,
StandardLaborCost = ?, StandardMaterialCost = ?,
StandardBurdenCost = ?, ActualCost = ?,
ActualLaborCost = ?, ActualMaterialCost = ?,
ActualBurdenCost = ?, ActualMaterialBurdenCost = ?,
ActualVariableBurdenCost = ?, ActualFreightCost = ?,
ActualOutplantCost = ?, CurrentDateScheduledComplete = ?,
OriginalDateScheduledComplete = ?, SecondRoutingSequence = ?,
ThirdRoutingSequence = ?, SecondWorkCenter = ?,
ThirdWorkCenter = ?
WHERE (WorkOrderNumber = ?)