Output error

[kateorme]

Hi,

Can anyone help with this error message: PLAESE

Error: Output Data (216): DataWrap2ODBC::SendBatch: [Microsoft][ODBC Driver 17 for SQL Server]Datetime field overflow Insert into "PersonalMilageData"("ID","GCI","EmployeeNumber","FirstName","LastName","HomeBusinessGroup","HomeBusinessLevel1","HomeBusinessLevel2","HomeBusinessLevel3","HomeTeam","HomeCostCentre","HomeLineManagerGCI","EmployeeType","EmployeeStatus","EmailAddress","EmpFunction","FileName","FileDate","DataLoadDate","DataDateStamp","ExpenseType","Supplier","TransactionDate","Spend","TripMiles","OriginCity","DestinationCity","OriginKeyLocation(Mileage)","OriginLatitude(Mileage)","OriginLongitude(Mileage)","DestinationKeyLocation(Mileage)","DestinationLatitude(Mileage)","DestinationLongitude(Mileage)","Origin-Destination","Latitude","Longitude","Path") Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

TIA

[nagakavyasri]

Check the datatypes of the insert values with that of datatypes set in Database.

[kateorme]

Hi, thanks for replying.

Can you please explain in a more detail what you mean? I am a new user to Alteryx and I am not quite understanding what I need to check

Many thanks

[mceleavey]

Hi @kateorme ,

you need to check your data types from the Alteryx workflow compared to the data types within the destination table.

In your example, you have the following:

Datetime field overflow Insert into "PersonalMilageData"

This means you have a field in Alteryx which is a Datetime field type. The destination field "personalMilageData" is not a datetime field, and is probably either a date or a string.

You need to ensure all fields are mapped and the data types are the same.

M.