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 |
|
bhman79
Starting Member
10 Posts |
 Posted - 2012-05-23 : 13:53:50
|
| I have created some simple import and export packages, however, I need to get a little more complicated. If I have a text file that logs part numbers and quantities, what are the steps to then find the part number in a table and increase the inventory level of that field by the quantity in the text file. Example:Current inventory of Part Number A is 2.The text file shows 3 more Part Number A's created.The DTS updates SQL to 5.Thanks in advance! |
|
|
|
|
|
Increasing inventory number using DTS