Splunk Enterprise

Splunk ODBC connection for SSIS package

New Member

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.

TITLE: Microsoft Visual Studio

Error at Data Flow Task 1 [ODBC Source [1]]: 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?


Tags (1)
0 Karma
Get Updates on the Splunk Community!

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...

Reminder! Splunk Love Promo: $25 Visa Gift Card for Your Honest SOAR Review With ...

We recently launched our first Splunk Love Special, and it's gone phenomenally well, so we're doing it again, ...