Look up operation in SSIS 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Look up operation in SSIS 2005

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-06-13 : 03:52:38

Dear All,

I need to import to a data from another table which is having reference to some other table.

How do i import this kind of data using SSIS

Thanks,
Gangadhar

Thanks,
Gangadhara MS
SQL Developer and DBA

latch
Yak Posting Veteran

62 Posts

Posted - 2011-06-13 : 10:30:38

You have to use Look Up transformation in Data flow task of the SSIS package:

Take Oledb source as your first table (which you have to refer) and then a look up transformation for referencing table which have the main values.
You have to configure the lookup transformation as:

Cache mode: FULL CACHE
Connection type: OLEDB CONNECTION MANAGER

specify how to handle rows: depending on your criteria( usually Ignore)

Then connection to your database and table.

And the column to which u want to compare.

for your reference for configuration: see these:

http://www.sql-server-performance.com/2009/SSIS-New-Features-in-SQL-Server-2008-Part2/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources