Message-ID: <3FF46326.B201E299@yahoo.net> From: Hans Forbrich X-Mailer: Mozilla 4.8 [en] (Win95; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle Subject: Re: Creating a DTS package programaticaly References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 20 Date: Thu, 01 Jan 2004 18:14:51 GMT NNTP-Posting-Host: 161.184.143.77 X-Trace: clgrps13 1072980891 161.184.143.77 (Thu, 01 Jan 2004 11:14:51 MST) NNTP-Posting-Date: Thu, 01 Jan 2004 11:14:51 MST Pattnayak wrote: > > Hi, > I want to create a DTS package programatically (preferably in > C#.net),which will copy all my tables from a oracle database to my > sql-server database. > Can anybody help me doing this??? > Thanks > Patnayak I suggest strongly that you start by looking at Oracle's documentation available publically at http://docs.oracle.com and specifically look for heterogeneous services. Are you in the MCA program as well? If so, please advise your fellow students that the instructor is probably monitoring this newsgroup. Also please note that this newsgroup is officially replaced by comp.databases.oracle.misc, and has been for several years. Not all possible respondents will be able to see your question here.