This post describes how to load a set of tables from the Tableau server repository. Tableau server repository uses PostgreSQL. You might need to install the PostgreSQL database drivers. You can download drivers from www.tableau.com/support/drivers.
Create a SSIS ODBC connection
Use ODBC connection in SSIS
Some useful tables are:
Cheers!
Uma