From: "Ana C. Dent" <anacedent@hotmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle
Subject: Re: Creating a DTS package programaticaly
References: <a57a07c8.0401010304.434f49c8@posting.google.com>
In-Reply-To: <a57a07c8.0401010304.434f49c8@posting.google.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 14
Message-ID: <vBVIb.45102$BQ5.23208@fed1read03>
Date: Thu, 01 Jan 2004 05:51:22 -0800
NNTP-Posting-Host: 68.7.204.31
X-Complaints-To: abuse@cox.net
X-Trace: fed1read03 1072965083 68.7.204.31 (Thu, 01 Jan 2004 08:51:23 EST)
NNTP-Posting-Date: Thu, 01 Jan 2004 08:51:23 EST
Organization: Cox Communications


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
DTS? What is a DTS (package)?
Do you want to "push" the data from Oracle to SQL-Server
or pull the data from Oracle to SQL-Server?