The aim is to use splunk ODBC driver to connect to splunk from SQL Server using visual Studio (SSIS), run a search, export the results to a table in SQL Server.
I was able to configure the ODBC connection. however when I try to run a Splunk query, I get the error as below.
Error at Data Flow Task 1 [ODBC Source ]: Open Database Connectivity (ODBC) error occurred. state: '42000'. Native Error Code: 31480. [Splunk]SQLEngine syntax error near 'GK_Daily_Camera_Mac_Checkins<<< ??? >>>'.
Can any one let me know a resolution?