I don't think you'll have much success with that approach. From what I remember you need to use the InfoBright file loader (ASCII files, or binary files if you have InfoBright Enterprise) to get performant data loads.

You might still be able to automate it with SSIS though, perhaps using SSIS to export data to a file and then run a script to load the data via InfoBright loader using the mysql command line?