community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

In-Database datatype change

Highlighted
Meteor

Hello,

 

I've run into an issue where the in-database tools are converting my "date" datatype fields to V_WStrings.

Attached is a screen shot example.Alteryx.png

Alteryx
Alteryx

Hi @Kieran

 

From previous experiences this is normally an issue caused when using the Microsoft OLE DB Provider for SQL Server drivers.

Instead use the SQL Server Native Client 11.0 driver:

OLEDB Driver.jpg

 

Using the Microsoft OLE DB Provider for SQL Server drivers:

OLE DB1.jpg

 

Instead use the SQL Server Native Client 11.0 driver:

SQL Native.jpgDateField.jpg

Christian Rincon
EMEA Team Lead, Customer Support
Alteryx
Meteor

Thank you sir...

Labels