Creating a DTS package programaticaly

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Pattnayak
    #1

    Creating a DTS package programaticaly

    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
    Tags: None
    • Ana C. Dent
      #2
      Re: Creating a DTS package programaticaly

      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?



        Comment

        • Hans Forbrich
          #3
          Re: Creating a DTS package programaticaly

          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.

            Comment

            • Ross McKay
              #4
              Re: Creating a DTS package programaticaly

              On 1 Jan 2004 03:04:13 -0800, Pattnayak wrote:
              >I want to create a DTS package programatically (preferably in
              >C#.net),whic h will copy all my tables from a oracle database to my
              >sql-server database.
              >Can anybody help me doing this???
              G'day Patnayak,

              If you do decide to use DTS for your table copies, then you'd be better
              asking in this newsgroup:

              microsoft.publi c.sqlserver.dts

              Also, you should check out this website:

              http://www.sqldts.com/


              As for building a package programmaticall y, DTS will happily give you
              some sample code. Just build a package graphically in the designer, Save
              As and set Location to Visual Basic File. Then start reading the code.
              It isn't the best code (i.e. you can rewrite it a lot better, it is
              simplistic auto-generated code) but it will give you an understanding of
              how it all works. You will also need to read the sections in BOL (Books
              On-Line) or MSDN that cover the DTS object model. Check out the website
              above to find out how to do it in C#.

              Having gotten that out of the way, why do you want to use DTS to do
              this? As other respondents have mentioned, there are other ways that
              might be more suitable.

              cheers,
              Ross.
              --
              Ross McKay, WebAware Pty Ltd
              "The lawn could stand another mowing; funny, I don't even care"
              - Elvis Costello

                Comment

                Previous template Next
                Working...