none
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?

    Thanks!

    Monday, July 13, 2015 10:41 AM

Answers

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

    https://www.rssbus.com/kb/articles/ado-ssistask.rst


    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:
    https://visualstudiogallery.msdn.microsoft.com/52034498-6cf4-4c12-b560-e3712962ec58

    To download the component, please go to there:
    http://www.cdata.com/drivers/bigquery/ssis/

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Thursday, July 16, 2015 9:40 AM
    Moderator
  • 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.

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

    Saturday, May 23, 2020 2:51 PM