Transfering Tables from Oracle to SQL Server 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transfering Tables from Oracle to SQL Server 2000

Using the Wizard I have created a DTS package to transfer a Oracle table to a SQL Server database. The data is transfered but not the indexes. Is it possible to transfer the indexes over? I am using the Microsoft OLE DB Provider for Oracle to connect to the Oracle database and I am using the Microsoft OLE DB Provider for SLQ Server to connect to the SQL Server. Laura Cerniglia
Hi, When you used the wizard to create the dts package, did you use the transfer object option?
Not sure if this helps, but you might want to check out:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
http://support.microsoft.com/default.aspx?scid=kb;EN-US;280106
http://support.microsoft.com/default.aspx?scid=kb;EN-US;259959 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
]]>