July 2, 2015 at 12:02 am
Comments posted to this topic are about the item Data Load Optimisation using the SSIS Balanced Data Distributor
July 2, 2015 at 7:53 am
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.
July 6, 2015 at 8:49 am
Wish I had know about this a year ago!!!!
July 7, 2015 at 6:51 am
I have SSMS 2012 installed. Does my server box have to have SQL Server 2012 installed too or will 08 R2 work?
July 7, 2015 at 7:15 am
The balanced data distributor works with all versions of SQL Server from 2008.
Link to 2008 version here:
All the best,
July 14, 2015 at 5:35 am
Excellent. Just wondering why Microsoft doesn't put it in SSIS by default?
August 11, 2015 at 6:34 am
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.
August 30, 2015 at 12:18 pm
Followed your steps and it worked first time, thanks great article.
Could have added Triumph Vitesse to the stock list. 😉
August 30, 2015 at 12:40 pm
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 ... 🙂
August 30, 2015 at 12:56 pm
Nice, I had a Vitesse, best car I ever owned.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply