Advertisement

07.08.2008 at 01:11AM PDT, ID: 23545757
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.7

Update Table Using SSIS

Asked by godwineffiong in MS SQL DTS, SQL Server 2005

Tags: ,

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
[+][-]07.08.2008 at 01:23AM PDT, ID: 21951863

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 30-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.08.2008 at 08:20AM PDT, ID: 21954667

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.09.2008 at 10:52PM PDT, ID: 21970675

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, SQL Server 2005
Tags: SQL Server, 2005
Sign Up Now!
Solution Provided By: nmcdermaid
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20081112-EE-VQP-44 / EE_QW_2_20070628