I have also found that if you're having problems with headers (text boxes above the tablix(s)), you can just add rows above the tablix header row. Then you can merge and center as you wish, only affecting the row you specify. Also, this will not create ghost columns (blank columns between columns of data).
If this does not work for you, SSIS is going to be your best choice.