Data Load Optimisation using the SSIS Balanced Data Distributor

Question

Data Load Optimisation using the SSIS Balanced Data Distributor

Adam Aspin

SSCarpal Tunnel

Points: 4900
More actions
July 2, 2015 at 12:02 am

#299715

Comments posted to this topic are about the item Data Load Optimisation using the SSIS Balanced Data Distributor

Viewing 10 posts - 1 through 9 (of 9 total)

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

Thanks for the info. This is far more complex to me than I can take in with one read through. I'll need to go over it more closely.

kferrara Old Hand Points: 398 More actions · Answer 2

kferrara

Old Hand

Points: 398

July 6, 2015 at 8:49 am

#1810471

Wish I had know about this a year ago!!!!

louie1487 78804 SSC Eights! Points: 903 More actions · Answer 3

I have SSMS 2012 installed. Does my server box have to have SQL Server 2012 installed too or will 08 R2 work?

Adam Aspin SSCarpal Tunnel Points: 4900 More actions · Answer 4

Hi Louie,

The balanced data distributor works with all versions of SQL Server from 2008.

Link to 2008 version here:

http://www.microsoft.com/en-us/download/details.aspx?id=4123

All the best,

Adam

nzhang6666 SSCrazy Points: 2217 More actions · Answer 5

Excellent. Just wondering why Microsoft doesn't put it in SSIS by default?

DennisPost SSCrazy Points: 2691 More actions · Answer 6

Hi Adam,

Thanks for taking the time to write!!

I have seen a Conditional Split used to do this.

RowNumber % 4 == 0

RowNumber % 4 == 1

RowNumber % 4 == 2

RowNumber % 4 == 3

Why is this component better?

The conditional split ignores the amount of rows and the read speed.

quackhandle1975 SSChampion Points: 11055 More actions · Answer 7

Followed your steps and it worked first time, thanks great article.

Could have added Triumph Vitesse to the stock list. 😉

qh

[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Adam Aspin SSCarpal Tunnel Points: 4900 More actions · Answer 8

I once had a Triumph TR4 - what a motor!

The apogee of British engineering, it added real joy to driving. Not to mention the surprise factor if you turned the wheel one way and the car actual followed ... 🙂

quackhandle1975 SSChampion Points: 11055 More actions · Answer 9

Nice, I had a Vitesse, best car I ever owned.

qh

[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]