loading table through diff data sources through DTS package

• swatianand83

  SSC Eights!

  Points: 930

  More actions

  November 8, 2008 at 4:57 am

  #75359

  I have to load a table present in sql server 2000 database. The source for this table is 3 tables: one present in sql server 2005 DB and 2 in oracle. these 3 tables are to be joined on the basis of few columns and then the resultant data set will be inserted to the target table.

  Any suggestions of how can it be done?

  Thanks

• nikhil8960

  Right there with Babe

  Points: 746

  More actions

  December 10, 2008 at 2:34 am

  #910170

  May be you can pull data from oracle tables to some text file on SQL server or some temp table in SQL server then you can use joins.