datetime2 vs datetime

[Former Member]

I just migrated from DS 3.2 to DS 4.2. In my preliminary testing, I came across the following error:

ODBC data source <server name> error message fro operation <SQLExecute>:<[Microsoft][SQL Server Native Client11.0] Datetime field overflow. Fractional second precision exceeds the sacale specified in the parameter binding>

This job was running fine with 3.2 using SQL Server 2008 R2 and somehow, it failed here with 4.2 and SQL Server 2008 R2 with a SQL Server Native Client 11 Driver.

Could anyone help me out or at least let me what was done wrong (I did not change anything as of yet).

Thanks all.

Adam

[Former Member]

There are two datetime2(7) columns in the source table and there are two equivalent datetime columns in the target table and I think this is what the above error message was referring to...

[Former Member]

The error message says datetime field overflow, which means the value size is more than the field length. There is always a problem in datatime conversion with the SQL server. What you could try is a cast() function to convert it in DI before loading.