Scribe Workbench: Conversion failed when converting date and/or time from character string.

Problem: During an insert step in Scribe Workbench, I wanted to populate a CreatedDateTime field with the current time. This field is a datetime2 in the SQL server. So I put in NOW( ) like this: But, instead of capturing a timestamp and putting it in, I got the following error in the execution log:… Continue reading Scribe Workbench: Conversion failed when converting date and/or time from character string.

Published
Categorized as ETL