ABerkowicz
MIS
I am trying to use snapshot replication on SQL 2000. I set up the publisher, distributer, and subscriber. Everything works fine if I copy one table to the other without any transformation. As soon as I say that I want to transform using VB script and add some code (something simple like UCase) and try to run replication routine, it fails with the error "Invalid Class String".
It creates the bcp file and then looks like something happens when trying to run the DTS package to insert/transform data to the subscriber. Any ideas on what the problem can be?
It creates the bcp file and then looks like something happens when trying to run the DTS package to insert/transform data to the subscriber. Any ideas on what the problem can be?