Post reply

DTS

  • May 12, 2009 at 12:31 am

    #131330

    How to combine many DTS package to one package.

    For example,

    I did a DTS package for Customer table including fields mapping to new table.I named the package as Customer.

    Then second package for Psalesorder table with same process.The package named as Psalesorder.

    Pls help ......

  • May 12, 2009 at 8:55 am

    #993026

    There isn't any way to actually combine packages. You'll have to add the tasks and workflow for one of the tables, say Psalesorder, to the package for Customer table.

    Another option would be to add an Execute Package task to one of the packages to execute the other package. So you could add the task to the Customer package and it would execute the Psalesorder package. See "Execute Package task" in BooksOnLine for details.

    Greg

  • May 13, 2009 at 12:11 am

    #993466

    Tq Greg ......

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

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