Solved

SSIS Sample Packages

Posted on 2009-04-01
8
527 Views
Last Modified: 2013-11-10
Specially how the lookup function work
0
Comment
Question by:ken hanse
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 9

Expert Comment

by:VikramMullick
ID: 24046730
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 24048027
You use to lookup for some value in a source depending on other source.
Tell me what you need and I will try to make an example for you.
Also check the attached images.
Regards,
Pedro
www.pedrocgd.blogspot.com
SSIS-Lookup.JPG
SSIS-Lookup2.JPG
SSIS-Lookup-Redirect.JPG
0
 

Author Comment

by:ken hanse
ID: 24055786
Is the lookup like subquery?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:ken hanse
ID: 24056001
Hi All,

Thanks for all who has responded to my query. I am really keen on learning SSIS and become a expert on that as I am working Data warehouse developer.
I have a requirment that I need to pass the table name through a variable and create a new table which is same structure for all the months. Just  names different based on the months.So this table is a cource table that I am populating data from Excell soruce file which reading from the same location and only name different.(same format for each month). I have attached a files which described some details for this question.
Thanks in Advance,
Regards,
Manj



Source-ExcelDestination-SQL-Tabl.doc
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24056902
It may be more polite to ask another question as this has nothing to do with your original one.
Also I would question that particular design - dynamically creating identical tables. Much of the focus of a data warehouse is combining disparate data into a single 'view' so that you can report over many things.
To put it another way, its more likely that an effective design would be to import your Excel data into a single table with an additional column which contains a month identifier.
0
 

Author Comment

by:ken hanse
ID: 24056956
Actually it is not the additonal columns, example take my word document, it has 3 fields both excel and table so there will be direct transform from excel to sql table. but each time it will create a seperate table
base on the new excel sheet for each months. and result will be one table for each month.
Basically what I need to do it pass the new excell file name to  a SSIS packege and then it will update the file connection and create table with the excell file name and import data into that table.
so hope my question is clear.
I think there will be some script task involve for this ETL. If you could provide me the solution I'll appreciate.
Regards,
Manjula
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24057275
Do you ever intend to merge this information into one table? Again if you're doing a data warehouse project, then one of the objectives is to get a single view of the data, not replicate an external system which by its nature splits the data up.
To put it another way, your source system has the data split by months, but that does not mean your data warehouse should. In fact it is the total opposite - you should be putting it in one table.
Anyway I don't know the full background so I won't comment on that area anymore.
Now to press another point: I beleive that Pedro has answered your original question, if you need more clarification on the lookup function, you can ask here.
0
 
LVL 22

Accepted Solution

by:
PedroCGD earned 250 total points
ID: 24058326
Dear Manjulagamage,
Set this question as resolved (lookup) and open a new one in order to avoid confusions to future users that will have the same issue.
Regards,
Pedro
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question