Even though from iSQL you may be able to query the tables from service now but from SSIS(visual studio) you may not be able to do so due to some settings.
Though there are several reasons for this issue, one of them is below:
Allow in-process option is disabled.
Go to server objects --> linked server --> providers --> msdasql --> enabling allow in process in the visual studio the query to fetch the incident details will work.
Also please try the below options as well if the above does not fix the issue:
1) Restarting the Visual Studio editor and start it using admin privileges only.
2) Restart the SQL server with the help of internal DBA.