I have three (3) tables:
a. Products with fields Id, SKU, ProdName, Category
b. ProductInventory with fields QtyOnHand and ProductId (a FK from table Products)
c. InvUpdate -- this is a "temp" table created from an external source (spreadsheet). Fields are: SKU, QtyOnHand
* Field Id on table Product is auto-generated.
** there are other fields in each table - but not required for this problem.
Problem:
a. I want to update the QtyOnHand on table ProductInventory using data from table InvUpdate.
Ideal logic would be:
Update ProductInventory Set QtyOnHand = InvUpdate.QtyOnHand
...
...
Where ProductInventory.SKU = InvUpdate.SKU
However, as you can see from my table structure this logic will not work because the ProductInventory table does not have a field called SKU.
b. I cannot / don't want to use a "manual" UPDATE statement as the "temp" table contains over 10,000 skus and the update process is going to be run weekly. I want to use SSIS.
Please help show me how I can use SSIS to UPDATE the qtyOnHand on ProductInventory table.
Thanks,
Start Free Trial
