Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need advice on designing DTS.. Expand / Collapse
Author
Message
Posted Sunday, August 22, 2010 1:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 2, 2011 12:10 PM
Points: 6, Visits: 27
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
Post #973094
Posted Thursday, September 9, 2010 8:56 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 11:26 AM
Points: 3,149, Visits: 7,976
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

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.
Post #983190
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse