When connecting to SQL Server, "date" datatype fields are changed to "V_WStrings"

[ntobon]

Environment Details

When connecting to SQL Server to pull data into the Input Data tool or In-DB tool, "date" datatype fields are changed to "V_WString"
 

• Alteryx Designer
  • All
• OleDB Driver

Table Structure example:





OleDB Connection:



Medatadata:

Cause

You are using driver 'Microsoft OLE DB Provider for SQL Server'

Resolution

Redo the connection and select provider 'SQL Server Native Client 11'
 

OleDB Connection:



Medatadata:


 
 

null