InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 15:48:34 GMT20http://www.sqlservercentral.com/Forums/Topic1369037-1550-1.aspxWhats the schema name for those tables? is that different from the other??Tue, 09 Oct 2012 23:54:13 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1369037-1550-1.aspx[quote][b]stillconfused (10/5/2012)[/b][hr]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.[/quote]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.ChandanTue, 09 Oct 2012 01:58:59 GMTchandan_jha18http://www.sqlservercentral.com/Forums/Topic1369037-1550-1.aspxMight 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 2000http://technet.microsoft.com/library/Cc917627Mon, 08 Oct 2012 13:06:59 GMTCYateshttp://www.sqlservercentral.com/Forums/Topic1369037-1550-1.aspxI 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.Fri, 05 Oct 2012 12:53:11 GMTstillconfusedhttp://www.sqlservercentral.com/Forums/Topic1369037-1550-1.aspxWow, haven't touched sql 2000 in 8 years.Can you elaborate more on what you mean you cannot even get all the tables?Fri, 05 Oct 2012 08:27:28 GMTRay Mhttp://www.sqlservercentral.com/Forums/Topic1369037-1550-1.aspxHi 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.Fri, 05 Oct 2012 07:37:01 GMTstillconfused