Quick summary of how process works.
Content processed in SQL 2000 and csv files created.
Content then loaded into Oracle.
I need to then re-import the content from Oracle back into SQL to ensure content was loaded correctly.
I am able to use enterprise manager and import the data, but ran into an issue when viewing the content. Basically SQL is stripping out the special characters (the slash over the e, the u with dots over it, etc) when the oracle data is brought into the sql db.
I'm needing a way to specify the code page to use when importing the oracle data back into the sql database. Would also prefer to get away from using enterprise manager since its pretty limiting and ruins the overall flow of the db.