Distinct in SSIS

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

nkm129 SSCommitted Points: 1763 More actions · Answer 1

Select TableA.ID,TableA .Name,Val,access

from TableA,TableB

Where TableA .id = TableB.Id

Thanks!

Venkatesan Prabu SSCommitted Points: 1892 More actions · Answer 2

Sir,

Do you think I dont know this query to fetch the data from two tables.

I have posted it in SSIS and I need some input in SSIS.

Regards,

Venkatesan Prabu .J

SQL Server Microsoft Most Valuable Professional

Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:

http://venkattechnicalblog.blogspot.com/

Crispin Proctor SSCoach Points: 18161 More actions · Answer 3

The sort task is the only stock component that can do a, well, sort.

There are other tasks out there that you can buy (nSort for one) that are better. But you have to pay for them.

If the stock Sort is really a problem, write your own with script component.

Add your key to a hash table. If key exists, throw the row away.

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

nkm129 SSCommitted Points: 1763 More actions · Answer 4

Use execute sql task component in control flow if you only need result set coming from this query or

use look up table make table b as lookup if you need data flow task..

Thanks!