Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SSIS

Avatar of rajeeva_nagaraj
rajeeva_nagaraj asked on
Microsoft SQL Server 2008
3 Comments1 Solution344 ViewsLast Modified:
Hi,

I have a query on SSIS, I have a SQL table (Productmaster) as below

OriginalProductIdProductName, Store1Code, Store2Code, Store3Code
001                         Apple                   101             201               301          
002                         Banana                 102             202               302
003                         Orange                  103             203               303


StoreMaster

StoreId  StoreName
1               S1
2               S2
3               S3

My Sales table
Store         ProductId      Qty      Amt
S1                 101              10         1000
S1                 102              10         1000
S1                 103                5           500
S2                 201                3           300
S2                 202                5           500
S2                 203                6           600
S3                 301                2           200
S3                 302                6           600
S3                 303                8           800

The output is combination of all the 3 tables
Storename    OriginalProductId        Qty          Amount
S1                        001                         10              1000
S1                        002                         10               1000
S1                        003                           5                  500
S2                        001                           3                   300
S2                        002                           5                   500
S2                        003                           6                   600
S3                        001                           2                    200
S3                        002                           6                     600
S3                        003                            8                     800

How can i do this with SSIS package, please its very urgent
ASKER CERTIFIED SOLUTION
Avatar of rajeeva_nagaraj
rajeeva_nagaraj

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers