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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

In-Database datatype change

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
Manager, Customer Support
Alteryx, Inc.
Highlighted
Meteor

Thank you sir...

Labels