Revision history [back]

To transfer data from Teradata to BigQuery using SSIS, you can follow these steps:

1. Install the Teradata ODBC driver on the machine where SSIS is installed.

2. Open SQL Server Data Tools (SSDT), create a new Integration Services package, and add a Data Flow Task.

3. In the Data Flow Task, add an ODBC Source component and configure it to connect to the Teradata database using the ODBC driver.

4. Add a Data Conversion component and map the Teradata columns to their respective data types in BigQuery.

5. Add a Google BigQuery Destination component and configure it to connect to the BigQuery project and dataset where you want to load the data.

6. Map the columns from the Data Conversion component to the corresponding fields in the BigQuery table.

7. Set up the data transfer options, such as the batch size and error handling.

8. Run the SSIS package to transfer the data from Teradata to BigQuery.

Note that you may need to adjust the configuration based on the specifics of your Teradata and BigQuery environments, and you may need to use additional components, such as transformations or lookups, depending on your data processing requirements.