locked
OLE DB Source data flow activity RRS feed

  • Question

  • I am new in SQL Server Integration Services. I create a project to transfer oracle database A to oracle database B. Tables structures are different between the 2 database. I create an OLE DB Source data flow activity and assign a table for it. Database A has about 50 tables. Should I create 50 OLE DB Source data flow activities (one OLE DB Source data flow activity for a table)?

     

    Thursday, April 22, 2010 7:36 AM

Answers

  • It's Business Intelligence Development Studio(integrated with Visual studio) where you create your Integration Projects(Packages).

    Cheers, Shailesh
    • Marked as answer by YEHOU Thursday, April 22, 2010 8:21 AM
    Thursday, April 22, 2010 8:12 AM

All replies

  • do you wish to just load the data between to databases without any transformation?

    Use Import/Export wizard in that case, It would create the package for you.


    Sudeep's Domain
    Thursday, April 22, 2010 7:40 AM
  • Thanks for your reply.

    Transformation is used between some tables (not all tables). Rest tables can be loaded without transformation.

    Thursday, April 22, 2010 7:48 AM
  • If Transformation is not required for some tables so you can create use Import/Export wizard in SQL SERVER , and for others table which require Transformation you can create separate Package in BIDS based on the Transformation.

    Cheers, Shailesh
    Thursday, April 22, 2010 8:05 AM
  • What's the BIDS. I am new in BI and SQL Server. Thanks

    Thursday, April 22, 2010 8:07 AM
  • It's Business Intelligence Development Studio(integrated with Visual studio) where you create your Integration Projects(Packages).

    Cheers, Shailesh
    • Marked as answer by YEHOU Thursday, April 22, 2010 8:21 AM
    Thursday, April 22, 2010 8:12 AM