Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.
3/24/2023: We are aware of the missing content issue and are currently looking into the matter. We appreciate your patience as we get this resolved.
Alteryx Designer Knowledge Base
Definitive answers from Designer experts.When connecting to SQL Server, "date" datatype fields are changed to "V_WStrings"
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
