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 10 (of 10 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]

Data Load Optimisation using the SSIS Balanced Data Distributor

Cookies on SQLServerCentral