Error creating ODBC connection with SSIS.

I m trying to connect TSpot to SSIS by following steps in manual.

But getting this error in SSIS while selecting odbc driver and schema in it in Connection manager.

The Data Access mode is Batch.

But wen selecting Name of table or view I am getting this error.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Naman Mittal I will reach out to you directly on this. It looks like you will need an additional port opened in order to establish the odbc connection.

    Like
Like Follow
  • Status Answered
  • 2 yrs agoLast active
  • 1Replies
  • 869Views
  • 2 Following