Importing a table from Oracle to SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Importing a table from Oracle to SQL Server

Author

Topic

kid_on_the_block
Posting Yak Master

172 Posts

Posted - 2005-06-06 : 13:27:24

Can anyone plz help me I want to import a table from Oracle to Sql Server 2000 .

When I use the DTS & Select Microsoft ODBC Driver for Oracle. It says that the Oracle client & netwroking components werenot found.

I have the Oracle client installed on my machine

Please help or suggest some other way to import the data into SQL Server

Thanks

X002548
Not Just a Number

15586 Posts

Posted - 2005-06-06 : 13:42:55

Why don't you unload the data from Oracle then use bcp to bring the data in to SQL Server.

It'll probably be faster

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

kid_on_the_block
Posting Yak Master

172 Posts

Posted - 2005-06-06 : 14:07:22

& how would that be

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources