Unable to query table from when usong service now ODBC from SSIS


Description

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.

Release or Environment

All

Cause

Though there are several reasons for this issue, one of them is below:

Allow in-process option is disabled.

Resolution

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.