"shunyen" <kate.s.chiang@healthnet.com> wrote in message
news:1175209502.943214.313370@d57g2000hsg.googlegroups.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?
>

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.googlegroups.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?- Hide quoted text -
>
> - Show quoted text -

"shunyen" <kate.s.chiang@healthnet.com> wrote in message
news:1175268021.364120.267330@p77g2000hsh.googlegroups.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:
>> 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.googlegroups.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?- Hide quoted text -
>>
>> - Show quoted text -
>
>