Solved

SSIS Sample Packages

Posted on 2009-04-01
8
535 Views
Last Modified: 2013-11-10
Specially how the lookup function work
0
Comment
Question by:ken hanse
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

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.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

738 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