Bulk Insert - Date issue

[samitshah78]

Hi,

I am trying to do bulk insert into Azure SQL Server and having date field in the dataset. Both source and target have date datatype, but it fails with error "_tds.ProgrammingError: Conversion failed when converting date and/or time from character string." When I change datatype on target to datetime, it works fine. I am using CTDS - 1.10. In my connection string, I am passing tds_version as 7.1 else it does not even try to connect with higher version of tds_version.

Please advise

[joshuahlang]

What version of FreeTDS are you using?