replication error

we are replicating from SQL 2000 to Oracle via linked server. and are
getting the following error "The process encountered invalid column
data in bcp file", the bcp file is too big to investigate it, any one
has any insight of this?
Did this ever work? By default SQL Server maps the SQL Server datatypes to
the Oracle datatypes, so it should be able to construct the table on Oracle
and bcp the data there. You might want to try it with a null filter to see
if the problem exists with the schema or the data.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"shunyen" <kate.s.chiang@.healthnet.com> wrote in message
news:1175209502.943214.313370@.d57g2000hsg.googlegr oups.com...
> we are replicating from SQL 2000 to Oracle via linked server. and are
> getting the following error "The process encountered invalid column
> data in bcp file", the bcp file is too big to investigate it, any one
> has any insight of this?
>
|||It worked before, the table got rebuilt and we have to recreate the
replication and this shows up. what do you meen to use a null
filter?
On Mar 30, 5:56 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> Did this ever work? By default SQL Server maps the SQL Server datatypes to
> the Oracle datatypes, so it should be able to construct the table on Oracle
> and bcp the data there. You might want to try it with a null filter to see
> if the problem exists with the schema or the data.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "shunyen" <kate.s.chi...@.healthnet.com> wrote in message
> news:1175209502.943214.313370@.d57g2000hsg.googlegr oups.com...
>
>
> - Show quoted text -
|||A filter that looks like this
where 1=2
It always evaluates to false.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"shunyen" <kate.s.chiang@.healthnet.com> wrote in message
news:1175268021.364120.267330@.p77g2000hsh.googlegr oups.com...
> It worked before, the table got rebuilt and we have to recreate the
> replication and this shows up. what do you meen to use a null
> filter?
>
> On Mar 30, 5:56 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
>