DTS Transform Data Task - How do you do it in SSIS?
Posted on 2011-03-07
After many frustrating hours with SSIS, I have given up trying to do what is a very simple task in DTS...
I have an Excel spreadsheet with 2 columns - PartNumber, and Quantity. I use it to update an Oracle table we'll call PartMaster. Pseudocode for the SQL Update command is something like:
Set PartMaster.Quantity = Excel.Quantity
Where Partmaster.PartNumber = Excel.PartNumber
I have tried dozens of SSIS tests to no avail, getting many different types of errors that I never had to worry about with DTS (like CodePage errors, Unicode conflicts, etc.).
Can anyone provide me with a complete SSIS example that will accomplish this?