import - export of dts package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » import - export of dts package

import - export of dts package

Rate Topic

Display Mode

Topic Options

Author

Message

stillconfused

Posted Friday, October 05, 2012 7:37 AM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, June 16, 2013 10:18 AM
Points: 29, Visits: 143

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

Ray M

Posted Friday, October 05, 2012 8:27 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 1,468, Visits: 941

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

stillconfused

Posted Friday, October 05, 2012 12:53 PM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, June 16, 2013 10:18 AM
Points: 29, Visits: 143

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

CYates

Posted Monday, October 08, 2012 1:06 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 6:17 AM
Points: 7, Visits: 99

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

chandan_jha18

Posted Tuesday, October 09, 2012 1:58 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 7:57 AM
Points: 415, Visits: 1,689

stillconfused (10/5/2012)

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

Ratheesh.K.Nair

Posted Tuesday, October 09, 2012 11:54 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:39 AM
Points: 2,425, Visits: 3,401

Whats the schema name for those tables? is that different from the other??

Post #1370689

« Prev Topic | Next Topic »

Permissions