Connect google bigquery to SQL Server with SSIS RRS feed

  • Question

  • Hi All,

    I need to load data to our SQL Server 2012 From google bigquery. I would like to do it with SSIS.

    What is the best way to connect to google bigquery through SSIS?


    Monday, July 13, 2015 10:41 AM


All replies

  •  RSSBus ADO.NET Data Providers to connect SQL Server directly with remote data via SSIS.

    St 1: Open Visual Studio and create a new Integration Services Project.
    St 2: Add a new Data Flow Task from the Toolbox onto the Control Flow screen.
    St 3: In the Data Flow screen, add a DataReader Source and an OLE DB Destination from the Toolbox.

    St 4: Add a new Data Connection, and select your provider as .NET Providers\RSSBus QuickBooks Data Provider.
    St 5: Enter the connection details for your QuickBooks machine. In this example, we are using a separate machine to host QuickBooks on.

    St 6: Open the DataReader editor. Go to the Connection Managers tab and select the Data Connection you just created.
    St 7: Keeping the DataReader Source open, go to the Component Properties tab and enter your SQL select command.

    St 8: Close the DataReader editor. Now drag the arrow below the DataReader Source to connect it to the OLE DB Destination.
    St 9: Open the OLE DB Destination and add a New Connection. Enter your server and database information here. In this example, we are using a separate machine running SQLExpress.
    St 10: Set your Data access mode to "table or view" and select the table or view to populate in your database
    St 11: Configure any properties you wish to on the Mappings screen.

    St 12: Close the OLE DB Destination Editor and run the project. After the SSIS Task has finished executing, your database will be populated with data obtained from QuickBooks


    Vote As Helpful if it helps to solve your issue

    • Edited by AV111 Monday, July 13, 2015 11:34 AM
    Monday, July 13, 2015 11:33 AM
  • Hi Avi_Bit,

    Since there is no build-in provider that can access data from Google BigQuery, we can use the custom SSIS Data Flow Source & Destination for Google BigQuery to connect and synchronize SQL Server with Google BigQuery data. For more details about it, please see:

    To download the component, please go to there:

    Katherine Xiong

    Katherine Xiong
    TechNet Community Support

    Thursday, July 16, 2015 9:40 AM
  • I have solve this using cdata and ssis 2012.Its easily connected with google big query.

    Wednesday, June 20, 2018 9:16 AM
  • You may also check the commercial COZYROC Google BigQuery connection.

    SSIS Tasks Components Scripts Services | http://wwww.cozyroc.com/

    Friday, June 22, 2018 10:49 PM
  • Google has an "Official" ODBC driver that works with SSIS.


    Saturday, May 23, 2020 2:51 PM