import - export of dts package

  • 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.

  • Wow, haven't touched sql 2000 in 8 years.

    Can you elaborate more on what you mean you cannot even get all the tables?

  • 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.

  • 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

  • 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

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply