July 22, 2004 at 8:43 am
I use Transactional Replication with DTS in SQL Server 2000. The problem it's that in the initial snapshot I got the next error (translated from spanish): "The process found invalid column date in the file bcp -path-". I rewieved the bcp file and I did't found special characters.In order to discard DTS package problems, the DTS did't have any transformations ony the transformations that SQL creates by dafault.This problem does not appear when I don't use DTS with the same data.Somebody has any ide about this error?Thank you for your information
July 23, 2004 at 1:28 pm
What version of SQL Server? SQL 2000 has its own snapshot generation that is pretty robust and doesn't use DTS as far as I know. If you can post some additional detail we may be able to assist. If all else fails generate your snapshots using the replication snapshot wizard.
Wes
July 27, 2004 at 10:52 am
Thank you .....
I have the next Transactional replication problems:
1) I performed transactional replication to Oracle subscriber.
The subscriber was configured using Micrososft OLE DB provider for Oracle, because I need to use DTS to transform the data before applying it to Oracle.
In the initial snatshop I got error (windows error) with distrib.exe:
The instruction at '<address>' referenced memory at '<address>'.
The memory could not be "read"
Click OK to terminate the program.
This problem appears with a table with a few rows. The only that I saw in the bcp file is that, there is some char(255) fields with blanks (like char(13), or returns in Word), when I removed some of this blanks from the bcp file and restart the synchronization the things go fine.
When I do the same replication of the same data to SQL subscriber it's fine too
2) The second problem with other table that I got: having the same conditions as described previously
In the initial snatshop I got error (replication error)
"The process encountered invalid column data in bcp file -PATH-"
Not error number and nothing more in the error description.
And the same, when I saw the bcp file and cut some blanks in field (character field) the things go fine.
With SQL subscriber it's fine too.
I did not use DTS in this case but the result is the same.
I reinstall SQL SP3 and Win2000 SP4 and I got the same result.
I don't know if there is a some deficiency with OLE DB providers when you used them with replication.
If you know how to resolve this problem, please say me.
Thank yoo for your time, and sorry for this long post.
July 27, 2004 at 3:52 pm
I have personally never done replication to an oracle database. I know it is supported I don't know if the default microsoft oledb drivers are enough. I would take a look on microsoft's web site for details on replication to non-sql server data sources. Sorry I couldn't help more.
Wes
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply