Hi there,

I was wondering if anyone could help me out to figure out how to use DTS in SQL Server 7.0 to export data to Oracle 7.3 database? I used MS OLE DB Provider for Oracle as the destination and the transformation was sucessful. However, it showed the destination table was not created in Oracle side and no data at all. Should I choose Oracle73Ver2.5, Microsoft ODBC Driver for Oracle or DataDirect Oracle7 OLE DB Provider as the destination?

Your any help would be highly appreciated!!