Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSIS: merging sql data with script transformation output - which tool?

Posted on 2010-08-30
4
Medium Priority
?
412 Views
Last Modified: 2013-11-10
I have a script transformation that is creating a dataset and I want to do lookup to other sql tables to pull in foreign keys to insert into another table. Do I use a Lookup or something else? Anyone have any links to examples I could follow?
0
Comment
Question by:wppiexperts
[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
4 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 300 total points
ID: 33558630
connect output of script component to a lookup transformation and set lookup table ( it must be an OLE DB Connection ) now you have match rows and non match rows output
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33558671
0
 

Author Comment

by:wppiexperts
ID: 33558906
what if I have up to 3 tables I want to bring in foreign keys from...do I need a seperate Lookup for each?
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33558999
if your input is 3 table, but your lookup table is one,
just merge all inputs with UNION ALL Transformation and then connect output of union all to lookup.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

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.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

715 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