I'm using VS 2019 with the latest version of SQL Server Integration Services Projects plugin. I have 2 local SQL Server instances installed on the same machine which are up and running (including Browser service). SQL Server is 2017 and 2019 (default and named instance respectively) and their Hide Instance flag is set to No.
When adding Data Link for Data Flow SSIS tasks (Destination or Source Assistant) server drop down not showing my SQL instances like that:
At the same time if I type in SQL Server instance name I can connect just fine. What can be causing my SQL instances not showing up here?
Best Answer
Just to close this off - you may see this problem depending on selected provider, if your provider set to "Native OLE DB\Microsoft OLE DB Driver for SQL Server" you may observe empty server drop down in Data Link Properties (exactly what we have on the screenshot in the question above), and just switching your provider to "Native OLE DB\SQL Server Native Client 11.0" resolves this problem. Actually this change changes UI slightly - you won't have "Data Links..." button next to OLE DB Provider which opens up Data Link properties as per screenshot in the question but it instead you will have Server Name drop down directly in Connection Manager window under Provider drop down as shown below: