I am trying to move data from Teradata to BigQuery using the Simba BigQuery ODBC driver in SSIS but I am getting errors either saying "The number of Columns is Incorrect" or "Dataset not Found" when I am trying to define the Big Query table name in ODBC destination.
I have tried all combinations like
ProjectID.Schema_Name.Table_Name
ProjectID:Schema_Name.Table_Name
ProjectID.Schema_Name.Table_Name
ProjectID:Schema_Name.Table_Name
Schema_Name.Table_Name
Table_Name
Am I missing something here?
