asked on
SSIS
Hi,
I have a query on SSIS, I have a SQL table (Productmaster) as below
OriginalProductIdProductNa
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
I have a query on SSIS, I have a SQL table (Productmaster) as below
OriginalProductIdProductNa
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
Microsoft SQL Server 2008
Last Comment
rajeeva_nagaraj
If you already have the query to create your report you can open up the Business Intelligence Development Studio, create a new Integration Services Project, then add in an Execute SQL Task object. Paste your query or queries to create your report into the Execute SQL Task object in the SQLStatement area. That's it. Then you can save your query to the server and execute it through a stored procedure or through a SQL Agent job.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I have found the way to fix the above issue by using the unpivot transformation