"Carla" <Carla@discussions.microsoft.com> wrote in message
news:B9386AF0-7D2C-4A50-A240-8BE70C1A2F0D@microsoft.com...
> I am activating a replication of the transacional type with only one
table.
> Everything enable normal, at the moment to pass the data appears the
> following message:
> String data, right truncation
> (Source: 172.18.7.22 (ODBC); Error number: 22001)
> --------------------------------------------------------------------------
-------------------------------------
> Unexpected EOF encountered in BCP data-file
> (Source: 172.18.7.22 (ODBC); Error number: S1000)
> --------------------------------------------------------------------------
-------------------------------------
> Violation of PRIMARY KEY constraint 'PK__PDVMAP__55AB7606'. Cannot insert
> duplicate key in object 'PDVMAP'.
> (Source: 172.18.7.22 (Data source); Error number: 2627)
>
> However in the destination it does not have these data, not have duplicate
> key, as much that I obtain to export the same data for the DTS.

"Hilary Cotter" wrote:

> Do you get this error if you use character mode format?
>
> Are you replicating to a table and dropping it before you recreate it?
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
>
>
> "Carla" <Carla@discussions.microsoft.com> wrote in message
> news:B9386AF0-7D2C-4A50-A240-8BE70C1A2F0D@microsoft.com...
> > I am activating a replication of the transacional type with only one
> table.
> > Everything enable normal, at the moment to pass the data appears the
> > following message:
> > String data, right truncation
> > (Source: 172.18.7.22 (ODBC); Error number: 22001)
> > --------------------------------------------------------------------------
> -------------------------------------
> > Unexpected EOF encountered in BCP data-file
> > (Source: 172.18.7.22 (ODBC); Error number: S1000)
> > --------------------------------------------------------------------------
> -------------------------------------
> > Violation of PRIMARY KEY constraint 'PK__PDVMAP__55AB7606'. Cannot insert
> > duplicate key in object 'PDVMAP'.
> > (Source: 172.18.7.22 (Data source); Error number: 2627)
> >
> > However in the destination it does not have these data, not have duplicate
> > key, as much that I obtain to export the same data for the DTS.
>
>