• You can use Merge join available in SSIS package