Thanks for posting your question in the Microsoft Q&A forum.
The Azure Synapse/Data Factory Salesforce (Legacy) connector will become deprecated on October 11, 2024. After this date, while you will no longer be able to create new Linked Services or datasets using the legacy connector, existing Linked Services and datasets will continue to function for a period. However, Microsoft has not specified an exact end-of-support date for the legacy connector, implying that it will eventually be phased out entirely.To ensure continued functionality and support, it is advisable to transition to the new Salesforce connector, which offers improved native Salesforce support and additional features
Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful