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
Posted Thursday, April 10, 2014 2:41 AM



Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 13,295, Visits: 11,086
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


Group: General Forum Members
Last Login: 2 days ago @ 5:06 AM
Points: 190, Visits: 1,514
Thanks..Phil Parkin and Koen Verbeeck.
will do that.

Post #1560366
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse