Date and (DateTime) Conversion from SQL Server

Just confirming that the best way to move DateTime fields from SQL Server is to CAST them using:

FORMAT(CAST([DateTimeField] AS DATETIME), ‘yyyy-MM-dd HH:MM:ss’)

The reason I’m asking is that I received a conversion error on one of my Panoply jobs.

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

~ NPT

Hi there,

The issue is the incremental key.
At the moment, we do not support datetime incremental keys with our SQL Server data source.
Changing the incremental column to type date or adding a new column that will be used as the incremental key with type date should do the trick.

Tell me if you have any questions,
Gal