How to parameterize database name in SSIS for ODBC driver
I have 2 tables in 2 different thoughtspot databases, Table A in DB 1 and Table B in DB 2. I wanted to move the data (around 30k record volume) on daily basis for which I wanted to use the ODBC driver.
I have tried removing the database parameter in ODBC configurations and use the database name while building the package, but it doesn't allow.
Is it possible to build pipeline connecting tables from different DB's?