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 5, 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 5, 2012 8:27 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, July 7, 2014 1:06 PM
Points: 1,478, Visits: 1,025
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 5, 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 8, 2012 1:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:24 PM
Points: 7, Visits: 124
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 9, 2012 1:58 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 12:51 AM
Points: 459, Visits: 1,888
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 9, 2012 11:54 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
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