loading table through diff data sources through DTS package

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply