Interview Questions - SSIS - Is it possible to use lookup transform on data from 2 flat file source?

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Interview Questions

This module helps you to share, discuss and learn interview questions and answers of different technologies


	Submit a Question


	Subscribe..

Home · Most Liked · Most Asked · Most Discussed · Sections

SSIS - Is it possible to use lookup transform on data from 2 flat file source?

May 1 2012 12:00AM by Sudeep Raj

Question

One of my favorite SSIS questions: Is it possible to use a lookup transform when the source are both flat files, and we do not have staging tables to dump these data, in SSIS 2008?

Answer

YES. It is possible, make use of cache transform, and then in look up task use this Cache connection instead of OLEDB Connection.

And the next question would be ..... Why do we then have Merge Join?

Read More.. [32134 clicks]

Published under: SQL Server Interview Questions · · · ·

Previous: Why can't a sparse column be eligible for Primary key?
Next: How can I define a DEFAULT value in a timestamp and IDENTITY column?

Sudeep Raj

12 · 13% · 4286

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview


	Submit

Your Comment

Sign Up or Login to post a comment.

"SSIS - Is it possible to use lookup transform on data from 2 flat file source?" rated 5 out of 5 by 6 readers +Sudeep Raj

SSIS - Is it possible to use lookup transform on data from 2 flat file source?

Question

Answer

Your Comment