Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2010-08-30
4
Medium Priority
?
413 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
  • 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

916 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