469,106 Members | 2,250 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

Copy Objects From a Linked Server


I have an Oracle 7.2 Server linked to the SQL Server 2000. It is visible
under the Linked Servers menu in the Enterprise Manager. Is it possible
to copy the objects from the linked server database to the SQL Server
database using the DTS package? I'd like to do it dynamically - I don't
want to add any tables manually to the package after a table appears in
an Oracle database. Is it possible?

Thanks for any advice.

...:: fabio
Jul 20 '05 #1
0 932

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by davidgordon | last post: by
7 posts views Thread by simkn | last post: by
11 posts views Thread by Nemisis | last post: by
35 posts views Thread by dragoncoder | last post: by
4 posts views Thread by colmkav | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.