I used Google Big Query Simba ODBC driver. It works but have some issue with SSIS.

https://cloud.google.com/bigquery/providers/simba-drivers

The above link has Google ODBC Driver download. Installation and configuring DSN are...