Can someone explain Output to database Data Configuration strings to me?

[Philip]

I'm confused by the the leading strings to the database connection references. I've seen:

aka:

ssvb:

ssvb:DSN=

What do the different references mean, and how should they look for a SQL Server Bulk Loader output string? Do they affect how the output is handled?

[MarqueeCrew]

the aka: looks like an alias and SSVB looks like a named connection.

The DSN= is where you've configured the system DSN.

https://www.connectionstrings.com/sql-server-native-client-11-0-oledb-provider/

It is best (as explained to me) to use the Native Client driver when possible.

Cheers,

Mark

[adm510 · Accepted solution]

aka is an alias from the Alteryx Data Connection window

ssvb refers to the sql server bulk loader

dsn is the name of the connection in the windows data source (data source name)

Also, make sure to double check your results window, if it's not configured correctly, Alteryx may revert you back to a standard ODBC connection instead of SSVB.  You can see the difference in the attached screenshot