Post reply

Need advice on designing DTS..

  • August 22, 2010 at 1:21 pm

    #222976

    Hi,

    I have table A with 4000 records(ID is the primary key). I want to develop a DTS package to iterate through the 4000 records in table A pass one id at a time to another task. This task then using the ID will pull dataset dependent on this ID to generate an excel. Overall there needs to be 4000 excels(with data set) for each ID.

    Can anyone suggest how to design this using one DTS job? (has to be a DTS job..no other option)

    thanks in advance

    TZ

  • September 9, 2010 at 8:56 am

    #1218685

    As you probably already know, DTS was not made for looping.

    I would probably do the looping inside an ActiveX script and have the script call the next step, passing the required information. How, good question.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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