Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

import - export of dts package Expand / Collapse
Author
Message
Posted Friday, October 05, 2012 7:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 21, 2013 8:31 AM
Points: 32, Visits: 167
Hi I am trying to import data from oracle to sql 2000 using dts package but unable to get all the tables.I am not even getting any error messgs.what can be the reason.how to figure out regarding this.
Post #1369037
Posted Friday, October 05, 2012 8:27 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:52 PM
Points: 1,478, Visits: 1,020
Wow, haven't touched sql 2000 in 8 years.
Can you elaborate more on what you mean you cannot even get all the tables?
Post #1369092
Posted Friday, October 05, 2012 12:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 21, 2013 8:31 AM
Points: 32, Visits: 167
I tried to get data from oracle using dts but I am unable to get couple of tables in sql . I am missing 2 tables. I am not even getting any info or error messgs.
Post #1369273
Posted Monday, October 08, 2012 1:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 10:15 AM
Points: 7, Visits: 115
Might want to give this a look over too; just to check your basis. It has been a long time for me as well in dealing with DTS and 2000

http://technet.microsoft.com/library/Cc917627
Post #1370006
Posted Tuesday, October 09, 2012 1:58 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:28 AM
Points: 449, Visits: 1,831
stillconfused (10/5/2012)
Hi I am trying to import data from oracle to sql 2000 using dts package but unable to get all the tables.I am not even getting any error messgs.what can be the reason.how to figure out regarding this.


First reach out to a guy managing that oracle database and give him the credentials that you use in the DTS package. Make sure he confirms it that this user should be able to read all the tables.

You should then confirm it by creating a linked server using those credentials to the oracle side and try finding if all tables are listed there.

Chandan
Post #1370210
Posted Tuesday, October 09, 2012 11:54 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,507, Visits: 3,645
Whats the schema name for those tables? is that different from the other??
Post #1370689
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse