This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 9%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidDataValue,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'when_updated_last_time' contains an invalid value 'Actual'.,Source=Microsoft.DataTransfer.ServiceLibrary,''Type=System.ArgumentException,Message=The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.Couldn't store <Actual> in when_updated_last_time Column. Expected type is DateTime.,Source=System.Data,''Type=System.FormatException,Message=The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.,Source=mscorlib,'
This error starting happening on our pipeline. We haven't changed anything and it was working fine before. Does anyone have any ideas on how to fix this?
An Azure service for ingesting, preparing, and transforming data at scale.
Hello @Sam Kersten ,
Just checking in to see if the below answer helped. If this answers your query, do click 
and upvote 
for the same. And, if you have any further query do let us know.
Hello @Sam Kersten , Following up to see if below answer helps you? If yes, please consider hitting Accept Answer button. Accepted answers help community as well. Please let us know if any further queries.
Answer accepted by question author
Hello @Sam Kersten
This error is due to the incoming data in the column when_updated_last_time
The column is of type: DateTime and the value coming from source is <Actual>
Can you check the source data / file for this column and see if it contains a value other than datetime type value
If yes then you will need to clean the data first before executing the pipeline again