SQL Server 2008 - DATE datatype support [NC]

Cedric ROUVRAIS <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <OFAA69DFAD.1B0E93DB-ON85257788.000087B4-85257788.0000AD1C@us.world.socgen>
Hi,

I'm having issues with performing a bcp into a date, not a datetime,
column. Is this an unsupported type or is it that I have configured or am
using the wrong version?

The error I get

dblib error: The result is truncated because the conversion/operation
resulted in overflow. Source data "2" should not exceed 10 chars

Thanks,

Cedric


*************************************************************************
This message and any attachments (the "message") are confidential, intended 
solely for the addressee(s), and may contain legally privileged information.  
Any unauthorised use or dissemination is prohibited.  E-mails are susceptible 
to alteration.  Neither SOCIETE GENERALE nor any of its subsidiaries or 
affiliates shall be liable for the message if altered, changed or falsified.
*************************************************************************
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.