Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

data transfer with SSIS multiple left join with source table Expand / Collapse
Author
Message
Posted Thursday, April 10, 2014 2:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
Phil Parkin (4/10/2014)
And regardless of where those servers are, you can still get rid of SORT components if you decide to keep the Merge Joins.


Good call. You can sort in the source components and remove these pesky blocking sorts.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1560288
Posted Thursday, April 10, 2014 5:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:29 AM
Points: 146, Visits: 1,116
Thanks..Phil Parkin and Koen Verbeeck.
will do that.

Post #1560366
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse