The problem with SSIS is unknown. It is probably best to resort to the SSIS-support channel.
Good news is that the browser download of table names works.
Please note that https://bridge-online.invantive.com/teamleader-focus-bridge-license/odata4/Teamleader.V2Flat.DealsAll@tlr can run for a very long time since it is a table function which can triggers thousands of API calls and last hours.
Please consider the use of V2.Deals@tlr whenever possible for upto 100x better performance as described in Huge performance improvement Teamleader Focus custom fields for Contacts, Companies and Deals.
Or add $top=10 to only retrieve the first 10 rows. That should complete within 10 seconds.