This works very similarly with the ODBC .net classes instead of the OleDb classes - same GetSchema & GetTableSchema methods, same/similar result sets, etc. (been there, done this).
What is really painful is then deciding to do the data pump in SSIS instead of using BCP.
I'd say...don't do this unless you're doing something like creating the resultant package to be run first in BIML or using CozyRoc's custom controls. It requires doing "design time" package manipulation with the SSIS design-time libraries in a script task to set up the pipeline, map fields, etc. It's a royally fragile, not well documented, PITA.