Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

ntobon
Alteryx
Alteryx
Created

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:

image.png



OleDB Connection:

image.png

Medatadata:

image.png

Cause

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



Resolution

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

image.png


OleDB Connection:

image.png

Medatadata:

image.png
 
 
 


null
No ratings