Creating a DTS package programaticaly

[Pattnayak]

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

[David Portas]

Re: Creating a DTS package programaticaly

BOL documents all of the DTS API:

http://msdn.microsoft.com/library/en-us/dtsprog/dtspapps_21rn.asp

Assuming you are using SQL2000 there's an easy way to familiarise yourself
with the basics of DTS programming. Create a sample DTS package (either
using the Wizard or the Designer), open it up in the Designer and choose
Package/Save As... from the menu. Select "Visual Basic File" from the
Location dropdown and specify a file name. This will generate the Visual
Basic code to create and execute your package. You can then dissect, edit
and extend the code as required.

Inevitably there will be some work involved if you want to move the
generated code to C# but the example of how to manipulate the DTS objects
should give you a helpful start.

--
David Portas
------------
Please reply only to the newsgroup
--

[Dan Guzman]

Re: Creating a DTS package programaticaly

To add to David's response, you can find a cookbook and examples for SQL
Server 2000 DTS with .NET at http://www.sqldev.net/dts/DotNETCookBook.htm.

--
Hope this helps.

Dan Guzman
SQL Server MVP


"Pattnayak" <dpatnayak@hotm ail.com> wrote in message
news:a57a07c8.0 401010301.3d175 545@posting.goo gle.com...[color=blue]
> 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[/color]