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?

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 10 mths agoLast active
  • 37Views
  • 1 Following